topic Calculated Dimension in QlikView

Calculated Dimension

evansabres — Wed, 05 Oct 2016 15:33:53 GMT

I have a field, transDTE, (it is a date field) which I would like to include in a chart. I would like to have the transDTE only display dates on or after 9/16/2016. What would the syntax be for this in a calculated dimension?

Re: Calculated Dimension

sunny_talwar — Wed, 05 Oct 2016 15:36:16 GMT

May be like this:

If(transDTE >= MakeDate(2016, 9, 16), transDTE)

and then select 'Suppress When Value Is Null' on the dimensions tab

Re: Calculated Dimension

Anonymous — Wed, 05 Oct 2016 15:37:32 GMT

try this

if(transDTE>=09/16/2016, transDTE)

Re: Calculated Dimension

evansabres — Wed, 05 Oct 2016 15:41:14 GMT

This seems to work, however, when I apply, the dates seem to now be out of order and are now random.

Re: Calculated Dimension

sunny_talwar — Wed, 05 Oct 2016 15:43:23 GMT

May be use a sort expression like this for this calculated dimension:

Only({1} transDTE)