Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I use column(columnNO) in set analysis?

Can I use column(columnNO) in set analysis?

For example {<DATE = {'<= column(4)'}>} ??

5 Replies
pover
Luminary Alumni
Luminary Alumni

After a simple test, this does not seem possible. That does not surprise me since set analysis does not respect the dimension values in a chart either since it is calculated before the expression is calculated for each dimension value. Use a sum(if()) instead.

Regards.

Not applicable
Author

I am suprised that columnNo() is not working in set analysis because rowNo() works out just fine.

gchavez
Partner - Contributor
Partner - Contributor

how would be to use sum( if() )?

mansoorsheraz
Creator
Creator

Hi @pover ,

Even after 13 years of your posting, this is still helpful today. I was looking for a similar issue and got it resolved exactly as you mentioned in just seconds.

Thanks a lot.

Regards.

mansoorsheraz
Creator
Creator

You may use it like this :

=Sum(if(<your_dimension_1>=<your_dimension_2>, [<your_value_dimension>]))

Hope this helps.