Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gouthamkk
Creator
Creator

Set Analysis Expression

Hi Experts,

I am trying to get count of using below expression

count({<[Date Closed] > $(VInputDate)> , <Status={'Closed'}>, <Severity= {'High'}>} Status)

The above expression was working fine without the date comparison "[Date Closed] > $(VInputDate)"

Date Closed is the database filed which has random dates and VinputDate is a variable which changes dynamically. I know this is simple but am struggle to get the total count of the status which Vinputdate is < Date closed.

It would be great if some one could help

Thanks

Goutham

Message was edited by: Goutham Kandukuri

18 Replies
Anonymous
Not applicable

try something like:

count({<[Date Closed] = {"> $(=VInputDate)"} , Status={'Closed'}, Severity= {'High'}} Status)

or

count({<[Date Closed] > {"$(=VInputDate)"} , Status={'Closed'}, Severity= {'High'}} Status)

mreinders
Creator III
Creator III

Hello Goutham,

try if it helps:

Count({< [Date Closed] = {">$(VInputDate)"}, Status = {'Closed'}, Severity = {'High'} >} Status)

Greetings

Michael

gouthamkk
Creator
Creator
Author

Hi,

sorry it is not working, i am getting black values, Do i need to use total or aggr function since i am using this as expression in chart table.

Not applicable

try below

count({<[Date Closed] = {"> $(=VInputDate)"} , Status={'Closed'}, Severity= {'High'} >} Status)

Vinay

Anonymous
Not applicable

depends on how your setup is. count returns one value. so if you are trying to use it as a dimension, then you need aggr.

if it is an expression, it will depend on your dimensions in the straight table...can you take screenshots or upload your file with sample data?

ps: just fyi, use advanced editor on the top right side of this reply textbox to attach files. (link to attach will be at the bottom right corner of your reply box in advanced editor mode)

gouthamkk
Creator
Creator
Author

Hi I just added the table chart

jerem1234
Specialist II
Specialist II

Should be:

count({<[Date Closed] = {'>$(=VInputDate)'} , Status={'Closed'}, Severity= {'High'}>} Status)


like is stated in previous posts. I'm interested in the formula for VInputDate. How are you calculating this? Does this change for each [Date Closed]?


It might be that set analysis might not work in your situation, and must add an if statement.


Hope this helps!

gouthamkk
Creator
Creator
Author

Hi,

I tried you expression, i am getting all values 0

gouthamkk
Creator
Creator
Author

VInputdate is an Input variable entered randomly, but i did check the date formats, they are right