topic Re: depend on field selection use set analysis in QlikView

depend on field selection use set analysis

karolina_ — Wed, 12 Feb 2014 10:30:16 GMT

Hi All,

I have below expresion:

=if(GetSelectedCount(Number),

concat({<CreationDate>} CreationDate,'|'),

concat(CreationDate,'|'))

The probles is that if Numer is not selected and I choose the date other row are still visible but without data.
I would like to have those rows hidden, but {<CreationDate>} seems to affect "else" choice.

This only happen if I display CreationDate

=if(GetSelectedCount(Number)<>0, sum({<CreationDate>} NPV), sum(NPV) ) is working fine.

I don't want to move CreationDate to dimension and check 'suppress when null' as CreationDate can have null values (anyway it shows error in calc)

Example attached.

Thanks

Re: depend on field selection use set analysis

whiteline — Wed, 12 Feb 2014 10:42:01 GMT

Hi.

What is the reason to use

=if(GetSelectedCount(Number),

concat({<CreationDate>} CreationDate,'|'),

concat(CreationDate,'|'))

instead of just

concat(CreationDate,'|')

Re: depend on field selection use set analysis

karolina_ — Wed, 12 Feb 2014 10:53:59 GMT

One of the next columns is using formula like:
=if(GetSelectedCount(Number)<>0, sum({<CreationDate>} NPV), sum(NPV) )

If I would not have =if(GetSelectedCount(Number),concat({<CreationDate>} CreationDate,'|'),concat(CreationDate,'|'))
I would only see selected CreationDate and other would have the cell empty.
With this formula I can see CreationDates for other products as well.

Re: depend on field selection use set analysis

whiteline — Wed, 12 Feb 2014 18:08:30 GMT

Hi.

You can use two separate expressions.

And set the appropriate show condition for each one. It works like you want.

Re: depend on field selection use set analysis

karolina_ — Thu, 13 Feb 2014 07:13:38 GMT

I did two tables which appear conditionally.

Didn't thought about 2 conditional expressions although I have other conditional columns in that table 😕

Do you know how is performance 2 conditional tables vs table with +2x8 conditional expressions?

Re: depend on field selection use set analysis

whiteline — Thu, 13 Feb 2014 18:54:14 GMT

Hi.

It's not so obvious. Generally 2 tables could have better performance, but QV caches the results for both for each user. Anyway, it seems that you don't have millions of rows,and can use the approach that is easier maintain.

Re: Re: depend on field selection use set analysis

karolina_ — Tue, 18 Feb 2014 11:15:20 GMT

Sory for late reply.
I checked version with conditional columns and it seems not working as expected (example attached) so separate table is a must.

Thanks for your time