topic Count IF in QlikView

Count IF

jlampard40 — Sat, 16 Nov 2024 02:18:09 GMT

Hi - I have the following set analysis which works really well, in counting all event keys greater than or equal to 14:

=Count({<WBR_Stat_Date = {"$(=Date(Today()))"}, Elapsed = {">14"}>} [WBR_Event_Key])

Can you tell me how to modify this so I can say (in a table) if an entry is greater to or equal to 14 than 'Yes' otherwise 'No'. I need some way for the users to be able to click on either a Yes or a No within the table and view the results. It's more meaningful for them than just a count. Many thanks.

Rgds

Re: Count IF

dplr-rn — Fri, 04 Oct 2019 19:45:48 GMT

While loading your data create a new column something like below

if(Elapsed <=14,'No','Yes') as [Elapsed Time Filter]

Re: Count IF

Brett_Bleess — Mon, 14 Oct 2019 12:31:42 GMT

James, below is a Design Blog post with info on Set Analysis and some other links to other posts as well, which may be helpful.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

I would think this should be as easy as switching your =Count to =If statement and set the Yes, No in the If... I am not a Set Analysis guru, so I am hesitant to take a shot at the syntax, but I cannot see that wrapping your statement inside the If statement should not do the trick. This will kick things back up, so one of the other development gurus may see things and confirm or deny my theory here... If you want both the count and the Yes/No, that may be a bit more tricky, and I believe if you want the users to be able to make a selection in a list box, you will need to use Dilip's post in that case, as you will need the Field in order to allow the users to select things I believe.

Regards,
Brett