Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Converting if to set?

I have two dimensional field named as BPA and EC , both are text.I have used an if clause can anyone help me converting it to to a set clause I have used the code below:


Result expected  all the EC names which satisfies BPA equal to Bill.

2 Replies

Re: Converting if to set?

Set Analysis must be used with Aggregation functions like Min, Max, Count, Avg, Sum etc.

What exactly you want to do here?

You can use something like below

COUNT({<BPA = {'Bil'}>}Distinct EC)

But from your above if statement, don't understand what exactly you are doing.

Please provide some more information so that we can help better way.

If you have used your If statement as a Calculated Dimension... then you can simply use EC there.

And use BPA field as a Set Expression


SUM({<BPA = {'Bil'}>}YourField)

New Contributor III

Re: Converting if to set?

I don't want any numeric field(no aggregation function). I wish to find those values (text) of the 'YourField'  column which satisfies 'BPA'(field name) ='bill' (value in that field).

Community Browser