topic Re: Calculated dimension not working in QlikView

Calculated dimension not working

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

below expression not working in calculated dimension but it's working in expression. kindly advise me. thanks

=if((Count({<Year={'*'},Week={'*'},Type_ID={'RO'}>} distinct OrderQty))>0, 'Repeat', '-')

Note: used pivot table

Regards,

Dev

Re: Calculated dimension not working

Anil_Babu_Samineni — Fri, 16 Dec 2016 07:13:30 GMT

Would you provide sample to work, Why it's not working because you can't do direct count in Dimension level. Might require aggregation function. Can you share the application?

Re: Calculated dimension not working

devarasu07 — Fri, 16 Dec 2016 07:45:59 GMT

Hi Anil,

Issue resolved,

=Aggr(if((Count({<Year={'*'},Week={'*'}>}distinct OrderQty))>0, 'Repeat', '-'),ArticleNo)