topic Re: flag on set analysis in QlikView

flag on set analysis

everest226 — Wed, 31 May 2017 22:02:09 GMT

HI i have MTDFlag for months and Daily.

and i have text object with the set analysis with following expression , i only want to change that object outcome when only selecting months but not by daily.

"count({<Date={'$(vExtractDate)'}, [ED Info.Event Type]={106}, WeekDay=, _HolidayFlag=>} Distinct [ED Info.Event ID])"

avinashelite‌

stalwar1‌

Re: flag on set analysis

rubenmarin — Wed, 31 May 2017 22:06:34 GMT

Hi, not sure to understand, maybe something with:

If(MTDFlag='MTD', count({<Date={'$(vExtractDate)'}, [ED Info.Event Type]={106}, WeekDay=, _HolidayFlag=>} Distinct [ED Info.Event ID]), [Else_Expression])

Re: flag on set analysis

Digvijay_Singh — Wed, 31 May 2017 22:16:43 GMT

May be something this -

"count({<Date={'$(vExtractDate)'}, [ED Info.Event Type]={106}, MTDFlag=P({<MTDFlag={'MTD'}>}),WeekDay=, _HolidayFlag=>} Distinct [ED Info.Event ID])"