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

[mrossoit]

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

[sagarkharpude]

count({$< Category = {'SDS*'},Month = {'=$(vOpendate)'},Resolve date= {'=$(vCurrentmonth)'} >} [Call Log ID])

Crete 2 variables for vOpendate & vCurrentmonth

[Anonymous]

When i tried i am getting error

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

[#5]

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

[sagarkharpude]

what are the values of vDumpOpenDate & vMaxMonth.

Are they matching with your fields Month & [SSR Resolve Date].

[Anonymous]

yes both format are same i getting syntax error

[Anonymous]

vDumpOpenDate=month(date(max([DumpOpen Date]),'MM'))

vMaxMonth=month(Date(Today(Date),'MM'))

[#9]

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

[Anonymous]