topic Re: Straight table display in QlikView

Straight table display

tmumaw — Mon, 10 Sep 2018 14:53:33 GMT

Good morning everyone,

Question for you. I have this straight table and I only want to show it when a refund amount is greater than zero.....any ideas?

Thanks

Re: Straight table display

vishsaggi — Mon, 10 Sep 2018 15:02:23 GMT

You mean you want to hide and show the straight table? If yes, then in your chart properties - Layout Tab - Conditional Check box. Write like

= Sum(RefundedSalesAmount) > 0

Change the field name as you used in your straight table expr. Not sure so just named RefundedSalesAmount. Hope you get it.

Re: Straight table display

tmumaw — Mon, 10 Sep 2018 15:41:49 GMT

You can see I have columns with a refund amount and columns where refund amount is equal to 0. I only want to show the customers who have a refund amount greater than 0.

Thanks

Re: Straight table display

atoz1158 — Mon, 10 Sep 2018 16:05:11 GMT

Try adding a dimension like the following and check "Suppress When Value is Null" box on the dimensions tab.

=If(Aggr(Sum([Refund Amount]),SortedBy,Customers)<>0,1)

I have guessed at your field names

And on the presentation tab hide the dimension column that has been added

Regards

Adrian

Re: Straight table display

vishsaggi — Mon, 10 Sep 2018 16:22:38 GMT

Create an aggr dimension like below then check supress null values

= Aggr(If(Sum(refundAmount) >0, SortedBy), SortedBy)