topic Re: count distinct with excluded dimensions ..help in QlikView

count distinct with excluded dimensions ..help

prees959 — Wed, 13 Dec 2017 00:01:44 GMT

Hi,

Im trying to use the following expression to display a 100% stacked bar chart :

Count( distinct {<[Type]={'OuterPerimeter'}>} PKEY) /

count(distinct <Date, [Fiscal Week],[Year_Month],[Year_Week],[Fiscal Yr],[Fiscal Qtr],[Fiscal Month],DayOfWeek> [ID])

but I'm getting an error on the :

count(distinct <Date, [Fiscal Week],[Year_Month],[Year_Week],[Fiscal Yr],[Fiscal Qtr],[Fiscal Month],DayOfWeek> [ID])

Can anyone advise how to correctly formulate this expression please?

Many thanks,

Phil

luismadriz — Wed, 13 Dec 2017 00:04:52 GMT

count(distinct {<Date=, [Fiscal Week]=,[Year_Month]=,[Year_Week]=,[Fiscal Yr]=,[Fiscal Qtr]=,[Fiscal Month]=,DayOfWeek=>} [ID])

I hope this helps,

Luis

prees959 — Wed, 13 Dec 2017 00:51:29 GMT

thanks so much!

Works perfectly

Phil