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: 
QlikDevPune
Contributor
Contributor

Above Function with Two Dates

QlikDevPune_0-1625213530373.png

I have two filters on the page. COB date and CompareDate

I want to show the two rows in the pivot table when user selects cob date and CompareDate in the rows.

the first row corresponds to value - which is for Cob date

the second row corresponds to value - which is for compare date

I want to create the third column called increment which shows the difference between the values of two cob dates value.

I have used above function. 

GetSelectedCount(cobdate) = 1 AND GetSelectedCount(CompareDate) = 1 AND GetFieldSelections(LevelsIndicator)='INCREMENTS',
((Sum({<cobdate ={'$(=GetFieldSelections(cobdate))'},[metricid]={2}>}[value]))-Above (Sum({<cobdate ={'$(=GetFieldSelections(CompareDate))'},[metricid]={2}>}[value]))),

it didnt work.

 

 

 

 

 

 

 

0 Replies