Discussion Board for collaboration related to Creating Analytics for QlikView.
I have the following fields in the Chart (Straight Table),
Expression Expression Expression
using using using
Set Analysis Set Analysis Set Analysis
value between value between AA set Analysis -
2 dates 2 dates BB set Analysis
Invoice_Num Amount (AA) Payment_Amount (BB) NET_AMT
A1 1000.00 500.00 500.00
B1 2000.00 2000.00 0.00
C1 3000.00 1500.00 1500.00
I want to show records where the NET_AMT is not zero, i.e. only show Invoice number A1 and C1. How can I do this.
Thanks in advance.
Go to Solution.
you have to write for both column AA and BB is
if(column(3)=0,expression for Column AA)
same for Column BB
and make sure check on Suppress Zero Value in Presentation Tab
Try to click on the search button of the list box. Then for not its <>. Im not sure if it works with <>0 or if you have to write <>0.00. Just try it.
Hi, please check app attached.
Thanks a lot. It works.
It didn't work.
Aitken Spence PLC
Tel: +94 11 2 308 043