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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

calculated dimension

Hi Expertise

Can you please explain me what is the below  calculated dimension do ?

=if([Deliver_Date]-[logindate] > 180, Dual('180+',4) ,if([Deliver_Date]-[logindate] >90, Dual('90+',3), if([Deliver_Date]-[logindate] > 30, Dual('30+',2), Dual('0-30',1) )))

This is really loading slow ..

how can i manage this in the script ?

Need help

Thanks in advance

1 Reply
Miguel_Angel_Baeyens

It is creating a classification based on the difference in minutes between deliver date and login date, from 1 (less than 30 minutes difference) to 4 (over 3h difference). If all those fields are already on the same table in your datamodel, you can basically include this line in the script as a new field and use this new field as the dimension.

If not, you will have to ApplyMap() or JOIN, or elaborate on how your model looks like so we can further assist.