Can I filter charts in Qliksense without it affecting the filters of other charts in my sheet, without using alternate states?

huangapple go评论95阅读模式
英文:

Can I filter charts in Qliksense without it affecting the filters of other charts in my sheet, without using alternate states?

问题

我想要有2个组合图表,一个筛选一个分支的销售额,另一个筛选另一个分支的销售额,这样我可以比较未来几个月的业绩,因为有一个重大项目正在实施。但筛选器影响了两个图表,而不是一个。

我无法使用“替代状态”。我在通过Chrome访问QlikSense Enterprise,公司要求我们停止使用桌面应用程序,因此我不能在桌面上访问任何流。只能使用云版本,所以我无法创建其他状态。

'=Sum({<Dimension1={'BranchName'}>}Sales)',然后另一个非常相似的,但具有不同的'BranchName'。

但我没有得到销售额,只有另一个度量的线。然后又有一个非常相似的,但具有不同的'BranchName'。

英文:

I want to have 2 combo charts, one with a filter looking at one branch's sales and one looking at another branch's sales, so I can compare performance for the next few months since there's a big project being implemented. But the filters keep affecting both charts rather than one.
I'm unable to use 'Alternate states'. I'm on Qlikesense Enterprise accessing it through Chrome and at my company, we've been told to stop using the desktop app so I don't have access to any streams on desktop. Only on the cloud version so I can't create another states.

'=Sum({<Dimension1='BranchName'>}Sales)' Then another very similar one, but with a different 'BranchName'.

But I'm not getting the sales figures. Only the line of another measure. Then another very similar one, but with a different 'BranchName'.

答案1

得分: 1

  1. 在处理这些情况的一种方法是利用变量和下拉变量输入对象。

  2. 在前端创建两个新变量,一个叫做 vBranch1,另一个叫做 vBranch2。任一变量的定义应为您希望它们默认为的分支名称。

  3. 向您的仪表板添加两个变量输入对象,并将它们设置为相应的变量,将它们设为下拉菜单,然后选择以下表达式中的 Dynamic 值选项:

    =Concat(all distinct [Branch Name], '&#39;|&#39;')

  4. 该表达式正在使用管道符 | 将分支字段中所有不同的分支值连接起来,不考虑其他选择(由于使用了 distinctall 关键字)。

  5. 在您的组合图中,在度量中使用集合分析,以便筛选您在变量下拉菜单中选择的分支:

    Sum({&lt;[Branch Name]={&#39;$(vBranch2)&#39;}&gt;} [Sales Amount])

  6. 现在您有了一个组合图比较,它将对非分支选择做出反应,但将保持与您在变量下拉菜单中选择的分支相对应。

英文:

One way I handle these situations is to utilize variables and the dropdown variable input object.

  1. Create two new variables in the frontend, one called vBranch1 and the other called vBranch2. The definition of either variable should be the branch names you want them to default to.

Can I filter charts in Qliksense without it affecting the filters of other charts in my sheet, without using alternate states?

  1. Add two variable input objects to your dashboard and set them to either variable, make them dropdowns, and then choose the Dynamic values option with the following expression:

=Concat(all distinct [Branch Name], &#39;|&#39;)

That expression is concatenating all distinct Branch values in your branch field with the pipe | symbol, regardless of other selections (thanks to the distinct and all keywords).

Can I filter charts in Qliksense without it affecting the filters of other charts in my sheet, without using alternate states?

  1. In your combo charts, use set analysis in the measure(s) to filter to whatever branch you have selected in the variable dropdown:

Sum({&lt;[Branch Name]={&#39;$(vBranch2)&#39;}&gt;} [Sales Amount])

And now you have combo chart comparison that will react to non-branch selections, but will stick to whatever branches you've selected in the variable dropdowns:

Can I filter charts in Qliksense without it affecting the filters of other charts in my sheet, without using alternate states?

huangapple
  • 本文由 发表于 2023年3月3日 19:39:57
  • 转载请务必保留本文链接:https://go.coder-hub.com/75626624.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定