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

expr correction?

avg({<period={'>$(=date($(vmaxperiod)-$(vdays))) <=$(=date($(vmaxperiod)))'} >}merticvalue/(100000))

-(minus)

avg({<period={'>$(=date($(vmaxperiod)-$(vdays))) <=$(=date($(vmaxperiod)))'} >}previousmerticvalue/(100000))

here

ex:

metricvalue:

day1,100

day2,200

day3,300

previous metric value means i want like

metric value is day1   then previous metric value is 0

metric value is day2   then previous metric value is 1

metric value is day3   then previous metric value is 2

i have only field is metricvalue   from this i have calculate prvious metric value

i have tried above function its not working

give me some idea when  metricvalue is day1 iwant prev metricvalue is 0

metricvalue is day2 iwant prev metricvalue is day1

metricvalue is day3 iwant prev metricvalue is day2

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

1 Reply
Anonymous
Not applicable
Author

got it