topic Re: Calculated dimension in QlikView

Calculated dimension

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

Dear Qlikview community,

I created a pivot table and I want to add a calculated dimension in order to group all regions.

Region is a dimension in my pivot table.

I used this expression : { <REGION = {"*"}>} but this didn't work.

The aim of this calculated dimension is to group the regions in one.

Please help me out, where is the mistake?

Best regards,

Abdallah

Re: Calculated dimension

sunny_talwar — Mon, 29 Oct 2018 12:28:37 GMT

So, for example if you have three regions A, B, and C... what exactly are you looking to see? ABC? or just a generic name like Region? or what?

Re: Calculated dimension

absekrafi — Mon, 29 Oct 2018 12:55:10 GMT

Hi Sunny,

Lets say I have region A, B and C.

and the name of my company is ABC, I would like to be able to group all regions in one new dimension (ABC) in a pivot table in order to get the total quantity sold, transferred and produced for example.

Abdallah

Re: Calculated dimension

sunny_talwar — Mon, 29 Oct 2018 13:14:22 GMT

So, all regions for the particular company? May be this as your 2nd dimension after Company

Aggr(Concat(Regions, ', '), Company)

Re: Calculated dimension

dplr-rn — Mon, 29 Oct 2018 13:38:55 GMT

If the regions are grouped under Company. Why the need for a separate dimension? You can use company as the dimension i would have thought.

Would be helpful if you have sample data and sample output

Re: Calculated dimension

absekrafi — Mon, 29 Oct 2018 14:03:56 GMT

Hi Dilip,

Regions are'nt grouped under company. I have an oracle table called region (regid, sigreg (short of the regions),...) but these regions are not grouped. I want to add a dimension which I can expand in order to group all the data related to these regions such as qte produced, qte sold, qte bought as so on (qte: quantity), in a pivot table.

U would like to attach part of what I have, but the attachement link is not available I will look where I can find it.

Re: Calculated dimension

sunny_talwar — Mon, 29 Oct 2018 14:14:23 GMT

Look here on how to attach

Uploading a Sample