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: 
Not applicable

Definition of Time Variables: how to ?

Hey Experts,

I have the date variable and a key figure(K). I have two questions regard this:

1) how to define a variable, which is: Knew =Avg (Km-1+Km-2), where m could be based on monthly or daily level.

I want to see the delta between the current Key figure and the average of 2 or 3 past month?

2) What is the best way to visualize the deviaiton, i mean are there some extentions that are best suited for this?

Thank you very much in advance,

best,

Rustam

0 Replies