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
Try:
=count({<Category={'SDS*'}, MonthName={"=$(vDumpOpenDate)"}, [SSR Resolve Date]={"=$(vMaxMonth)"}>}[Call Log ID])
Hi,
supposing Month is a numeric field and 'open date' is a possible value of [Resolve date] try this:
count({<Category = {'SDS*'}, [Resolve Date] = {'open date'}, Month = {'$(=num(month(today())))'}>} [Call Log ID])
Hope this helps
Regards,
MR
count({$< Category = {'SDS*'},Month = {'=$(vOpendate)'},Resolve date= {'=$(vCurrentmonth)'} >} [Call Log ID])
Crete 2 variables for vOpendate & vCurrentmonth
When i tried i am getting error
=count({<Category={'SDS*'},Month={'=$(vDumpOpenDate)'}, [SSR Resolve Date]={'=$(vMaxMonth)'}>}[Call Log ID])
What kind of error are you getting?
*Note: the format of Month and vDumpOpenDate variable value must be same and similar for SSR Resolve Date and vMaxMonth..
thanks,
Singh
what are the values of vDumpOpenDate & vMaxMonth.
Are they matching with your fields Month & [SSR Resolve Date].
yes both format are same i getting syntax error
vDumpOpenDate=month(date(max([DumpOpen Date]),'MM'))
vMaxMonth=month(Date(Today(Date),'MM'))
The set analysis expression looks good. Does it show Red line in the expression panel? Can you cross check the field names once again?
Also, we could put hard coded values for testing initally.
thanks,
Singh