Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Calculated Dimension

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?

1 Solution

Accepted Solutions
sunny_talwar

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

Only({1} transDTE)

View solution in original post

4 Replies
sunny_talwar

May be like this:

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

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

Anonymous
Not applicable

Hi

try this

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

evansabres
Specialist
Specialist
Author

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

sunny_talwar

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

Only({1} transDTE)