topic Re: Can I use column(columnNO) in set analysis? in QlikView

Can I use column(columnNO) in set analysis?

Tue, 30 Nov 2010 15:17:37 GMT

Can I use column(columnNO) in set analysis?

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

Can I use column(columnNO) in set analysis?

pover — Tue, 30 Nov 2010 22:29:07 GMT

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.

Can I use column(columnNO) in set analysis?

Wed, 07 Dec 2011 06:07:49 GMT

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

Re: Can I use column(columnNO) in set analysis?

gchavez — Mon, 20 Sep 2021 16:12:08 GMT

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

Re: Can I use column(columnNO) in set analysis?

mansoorsheraz — Sat, 04 Feb 2023 18:37:32 GMT

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.

Re: Can I use column(columnNO) in set analysis?

mansoorsheraz — Sat, 04 Feb 2023 18:39:09 GMT

You may use it like this :

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

Hope this helps.