Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gouthamkk
Contributor

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
jsaradhi
Valued Contributor

Re: Set Analysis Expression

try something like:

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

or

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

mreinders
Contributor III

Re: Set Analysis Expression

Hello Goutham,

try if it helps:

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

Greetings

Michael

gouthamkk
Contributor

Re: Set Analysis Expression

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

Re: Set Analysis Expression

try below

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

Vinay

jsaradhi
Valued Contributor

Re: Set Analysis Expression

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
Contributor

Re: Set Analysis Expression

Hi I just added the table chart

jerem1234
Valued Contributor II

Re: Set Analysis Expression

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
Contributor

Re: Set Analysis Expression

Hi,

I tried you expression, i am getting all values 0

gouthamkk
Contributor

Re: Set Analysis Expression

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

Community Browser