Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to combine IF condition and set analysis ?

    Here is my condition: 

 

=count (if([Days Remaining] <0, [Title ]))

 

Here is my set analysis:  

count ({$< [ Date.autoCalendar.InYTD]={1} ,[Date.autoCalendar.YearsAgo]={0}> } [Title ] )

 

If I try this :

 

count (if([Days Remaining] <0, 

({$< [ Date.autoCalendar.InYTD]={1} ,[Date.autoCalendar.YearsAgo]={0}> } [Title ])) 

This doesn't seem to work . It  returns a  '-'   in the kpi object

 

1 Solution

Accepted Solutions

How about this

Count({$<[ Date.autoCalendar.InYTD] = {1}, [Date.autoCalendar.YearsAgo] = {0}, [Days Remaining] = {"<0"}>} [Title ])

View solution in original post

3 Replies

How about this

Count({$<[ Date.autoCalendar.InYTD] = {1}, [Date.autoCalendar.YearsAgo] = {0}, [Days Remaining] = {"<0"}>} [Title ])

View solution in original post

Creator III
Creator III

Hey,

why do you want to use the if statement here? 

You can just add another condition to the calculation:

Capture.PNG

Contributor III
Contributor III

 It works Sunny ! Thank you so much.