Solved: Help in set analysis - Qlik Community

Report Inappropriate Content · ‎2016-03-16

Hi All,

I have calculated dimension as below

=if(match(status='Active',status)

How can I write the same in set analysis?

Kushal_Chawda · ‎2016-03-16

Instead of using calculated dimension use set analysis in expression like below

=sum({<status={'Active'}>}Value)

View solution in original post

Kushal_Chawda · ‎2016-03-16

Instead of using calculated dimension use set analysis in expression like below

=sum({<status={'Active'}>}Value)

tamilarasu · ‎2016-03-16

Hi,

Add dimension as status and set expression as Only({<status={'Active'}>}status)

Chanty4u · ‎2016-03-16

use only function

vikasmahajan · ‎2016-03-16

=if(status='Active',1,0)

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Help in set analysis

Related Topics