Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you do not have a field name called Month. Can you cross check?
quick tip: avoid using built-in field names
Upload your qvw. It will be easier and faster to help you.
PFA...
Try:
=count({<Category={'SDS*'}, MonthName={"=$(vDumpOpenDate)"}, [SSR Resolve Date]={"=$(vMaxMonth)"}>}[Call Log ID])
This is giving 0 as result, because for MonthName = Mar you have no SSR Resolve Date for the month of May.
{"=$(vDumpOpenDate)"} why we used "" here
can we use '' ?
but SSR Resolve Date i have data for Mar then y its getting 0
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
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.