topic Re: Limit dimension based on expression outcome in QlikView

Limit dimension based on expression outcome

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a fairly simple straight table with a couple of dimension and a few expressions:

Dim1	Dim2	SUM({<GEN={'ALL'}>}NUM)	=IF((SUM({<GEN={'ALL'}>}NUM))>9,AVG({<GEN={'ALL'}>}AP))
1	ABC	1	-
1	DEF	5	-
2	GHI	2	-
2	DEF	18	65.2
3	ABC	23	75.1
3	GHI	8	-
3	JKL	12	59.4

All I want is to not show the rows where the last column is null!

I've tried using a calculated dimension as follows:

=aggr(if(SUM({<GEN={'ALL'}>}NUM)>9, Dim2),Dim2)

But this isn't working for me!

Anyone have any ideas?

Thanks,
Jess

avinashelite — Wed, 21 Jun 2017 10:49:48 GMT

Try like this

aggr(if(SUM({<GEN={'ALL'}>}NUM)>9, Dim2),Dim1,Dim2)

jessica_webb — Wed, 21 Jun 2017 10:58:29 GMT

Perfect - thank you very much Avinash!

avinashelite — Wed, 21 Jun 2017 11:29:24 GMT

Your always welcome

Anonymous — Wed, 19 Jul 2017 11:56:33 GMT

Hi,

is this also possible via conditional show for the dimension?

I want to use a text field to switch between viewing all_orders and only open_orders

(sum(TotalQuantity) - ProcessedQuantity) > 0 = open_orders

thanks,

lucas