Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using a limitation on dimension

I am building my report to display data that I want to limit using a variable field.

I have a start date field that I only want reported if the date is more than 18 months ago. in effect it will report all historic sales agents that have not made a sale in a long time or never made a sale at all.

Is it possible to have calculated data as a limitation?

I am trying to use the calculated value as: date(today()-495,'DD-MM-YYYY')

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

Load *

From Source

Where DateField >= Date(Today()-495,'DD-MM-YYYY')

(DateField Format should match with calculated Date)

View solution in original post

5 Replies
shraddha_g
Partner - Master III
Partner - Master III

Load *

From Source

Where DateField >= Date(Today()-495,'DD-MM-YYYY')

(DateField Format should match with calculated Date)

Anonymous
Not applicable
Author

Is there no way that this can be achieved on the criteria for the selection in the table that I am trying to produce?

The results are going into a flat table instead of something that is graphically displayed to allow our staff the ability to see if there are sales agents who either have not made a sale or the date of the last sale was greater than the time required.

shraddha_g
Partner - Master III
Partner - Master III

you can use it in set analysis.

Please provide some sample data and expected output

Anonymous
Not applicable
Author

I have used a custom script to load the dates and filter the data to what I want with your help above, however, it is duplicating rows on my table.

I know the cause, it's an incomplete sale that was never really begun so the data started is missing.

I am trying to remove it using the following but it returns no data:

IF($(NoSaleCheck)='Sales',MaxSaleDate,NULL)

Edit:

Managed to figure it out, the IF criteria was wrong and should have been:

IF(NoSaleCheck='Sales',Date(MaxSaleDate),NULL())

thank you for your help shraddha.g

shraddha_g
Partner - Master III
Partner - Master III

Glad it helped!