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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to use date variable in set analysis

Hi,

I'm trying to use set analysis in a kpi formula.

I define the following variables:

vEndDate= max(enddate)

I have  to add this variable in below expression so that upon selection of  enddate the below measure expression value should also get change

count({<$(vEndDate),[flag]={'tag- 1','tag- 2','tag- 3','tag- 4',''},[tag]={'Extended Warranty','Service Contract'}
,[contract]={'Contract'}>}Business)

 

But it's giving me balnk value.

Labels (1)
1 Reply
Shubham_Deshmukh
Specialist
Specialist

Do you have any date filter? If selected date is max date then it should get apply, is it your requirement?