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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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