Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siewmei_lsm
New Contributor II

How to calculate changes between 2 date for a measure in pivot table

How to calculate the changes for 1 measure between 2 date in pivot table?

if  there are 2 measure i can easily use formula column 2-column 1 but for my case is only have 1 measure, and need to calculate the different between 2 date.

Capture.PNG

1 Solution

Accepted Solutions
MVP
MVP

Re: How to calculate changes between 2 date for a measure in pivot table

May be one of these

Expression - After(Expression)

or

Expression - Before(Expression)

or

After(Expression) - Expression

or

Before(Expression) - Expression

Replace Expression with whatever expression you have in your chart

1 Reply
MVP
MVP

Re: How to calculate changes between 2 date for a measure in pivot table

May be one of these

Expression - After(Expression)

or

Expression - Before(Expression)

or

After(Expression) - Expression

or

Before(Expression) - Expression

Replace Expression with whatever expression you have in your chart