Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
firoz24
Creator
Creator

Qlik sense kpi

Hi guys,

I have a data with two column as date and other column as value but when I filter first column date I need to get that sum and when I filter second column date I need to get the sum of that with respect to column names. So the Kpi needs to work as a optional either this sum or that sum. Please check and reply asap.

 

 

Labels (2)
3 Replies
anat
Master
Master

can you try by using pick and match 

firoz24
Creator
Creator
Author

No , Not working

Count({<[VIN]>}[Month of VP Report date]) - this is my set analysis when i filter vp report date column it should use this formula.

or 

Count({<[VIN]>}[Month of prod date]) - this is my second set analysis when I filter Month of prod date formula it should use this formula.

 

anat
Master
Master

If(getselectedcount(date1)>1, measure1, 

If(getselectedcount (date2) >1, measure2))