depend on field selection use set analysis

[karolina_]

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

[whiteline]

Hi.

What is the reason to use

=if(GetSelectedCount(Number),

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

concat(CreationDate,'|'))

instead of just

concat(CreationDate,'|')

?

[karolina_]

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.

[whiteline]

Hi.

You can use two separate expressions.

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

[karolina_]

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?

[whiteline]

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.

[karolina_]

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