topic Re: Calculated dimension in aggregated measure in QlikView

Calculated dimension in aggregated measure

sunitha_chellaiah — Thu, 26 Jul 2018 11:18:17 GMT

Hi All,

I want to add calculated dimension in my aggregated measure.

Suppose i have calculated dimension as

=if(left(Segment,2)='KT','Apparel Knitting' ,

if(left(Segment,2)='WV','Apparel Weaving' ,

if(left(Segment,2)='HT','Home Textiles' ,

if(left(Segment,2)='TT','Technical Textile' ,

'Others'))))

now i want to use this dimension in

=sum(aggr(fieldname, 'calculated dimesion'))

Please help.

Re: Calculated dimension in aggregated measure

sunny_talwar — Thu, 26 Jul 2018 17:08:09 GMT

I would recommend to do this if statement in the script so that you can use the field name within the Aggr() function....

Re: Calculated dimension in aggregated measure

Anonymous — Thu, 26 Jul 2018 17:22:01 GMT

Hi Sunitha,

If the Calculation can be added in the script instead of UI, a simple aggregation step will help to solve the issue..

Re: Calculated dimension in aggregated measure

sunitha_chellaiah — Fri, 27 Jul 2018 07:13:53 GMT

I want to do it in front end only.

Actually i want to use this calculated dimension in my ad hoc report. I have multiple dimensions in my report (around 20 including 2 calculated dimension). i want to use all the dimensions in Aggr().

Please help me with front end solution.

Re: Calculated dimension in aggregated measure

ogautier62 — Fri, 27 Jul 2018 07:28:50 GMT

Hi,

maybe two remarks :

- why don't use left(segment,2) as dimension (more simple as expression) and make a pick for label ?

- why do you need aggr in chart if you have this as dimension ?

regards

Re: Calculated dimension in aggregated measure

sunny_talwar — Fri, 27 Jul 2018 11:14:42 GMT

I don't think there is a solution...