topic how to write calculate dimension in QlikView

how to write calculate dimension

kunkumnaveen — Sat, 12 Aug 2017 09:11:19 GMT

Hi All,

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

part price

001 200

001 300

002 100

002 50

003 part shouldn't come because it has only one price even the date condition is valid

Re: how to write calculate dimension

Gysbert_Wassenaar — Sat, 12 Aug 2017 09:36:23 GMT

Perhaps with part as dimension and this expression:

sum({<date={">$(=date(today()))"},part={'=count({<date={">$(=date(today()))'}>}distinct date)>1"}>}price)

Re: how to write calculate dimension

kunkumnaveen — Sat, 12 Aug 2017 10:39:08 GMT

thanks for ur reply ,i tried ur expression ,but some how i am getting null values as o/p

Re: how to write calculate dimension

antoniotiman — Sat, 12 Aug 2017 12:28:04 GMT

Maybe like this

and don't forget to check 'Suppress when Null Value'.

Regards,

Antonio

Re: how to write calculate dimension

rubenmarin — Sat, 12 Aug 2017 14:46:15 GMT

Hi, maybe with an equal sign in $-expansion:

sum({<date={">$(=date(today()))"},part={'=count({<date={">$(=date(today()))'}>}distinct date)>1"}>}price)

Re: how to write calculate dimension

passionate — Sat, 12 Aug 2017 17:12:30 GMT

Hi Naveen,

PFA Solution.

Please let me know for issues.

Regards,

Pankaj