Discussion Board for collaboration related to Creating Analytics for QlikView.
How to write a calculated dimension ,so that to display only those parts which has more then one price and whose date is greater than today for selected supplier
from sample data as below
part supplier price date
001 xxx 100 01-05-2017
001 xxx 200 16-08-2017
001 xxx 300 31-12-2020
002 xxx 100 16-08-2017
002 xxx 50 22-09-2017
003 xxx 20 21-10-2017
006 yyy 100 24-10-2017
006 yyy 30 03-11-2017
if i select supplier xxx then i need to display this in normal table
003 part shouldn't come because it has only one price even the date condition is valid
Perhaps with part as dimension and this expression:
thanks for ur reply ,i tried ur expression ,but some how i am getting null values as o/p
Maybe like this
and don't forget to check 'Suppress when Null Value'.
Hi, maybe with an equal sign in $-expansion:
Please let me know for issues.