set

[Anonymous]

Hi all,

I am very new into Qlikview I want below statement in set analysis How to achieve it

Total no. of call logs where Category = SDS* , Month = open date and Resolve date = current month

count({....>}[Call Log ID])

Thanks

[#2]

I think you do not have a field name called Month. Can you cross check?

quick tip: avoid using built-in field names

[mrossoit]

Upload your qvw. It will be easier and faster to help you.

[Anonymous]

PFA...

[#5 · Accepted solution]

Try:

=count({<Category={'SDS*'}, MonthName={"=$(vDumpOpenDate)"}, [SSR Resolve Date]={"=$(vMaxMonth)"}>}[Call Log ID])

[#6]

This is giving 0 as result, because for MonthName = Mar you have no SSR Resolve Date for the month of May.

[Anonymous]

{"=$(vDumpOpenDate)"} why we used "" here

can we use '' ?

[Anonymous]

but SSR Resolve Date i have data for Mar then y its getting 0

[#9]

Single quotes are used as literals, so for evaluation we use double quotes.

for more details check: A Primer on Set Analysis

Hope this was helpful or correct.

Thanks,

Singh

[#10]

You have data for Mar but the variable you used is : vMaxMonth which has May as the value. That is why you are getting zero.