# 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
Did you mean:
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
MVP

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

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

Hey,

why do you want to use the if statement here?

You can just add another condition to the calculation:

Contributor III

It works Sunny ! Thank you so much.

Tags