topic New field/ Demension from field values in QlikView

New field/ Demension from field values

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

I have a field call class code and there are multiple values RR1,RR2,RR3,IG1,IG2,IG3,CA1,CA2,CA3,CA4.

i have to get the sum of sales for all a group of values for example all RR values.

I know i could use set analysis to define it for the expression but i cam trying to put it in a chart and have the group of values act like a field/dimension. So i would have 1 expression Sum(sales) and then dimensions RR,IG,CA all in a straight table.

Is it possible to create new fields or dimensions from field values ?

Thanks,

Re: New field/ Demension from field values

waszcma1 — Fri, 08 Mar 2019 21:45:58 GMT

Hi,

My first thought is:

In the loading data script create another field which will flag the records.

use this:

if(wildmatch([class code],'RR*'),'RR',if(wildmatch([class code],'IG*'),'IG','CA')) as Code_Flag

Now you have new dimension named Code_Flag

Re: New field/ Demension from field values

rwunderlich — Sat, 09 Mar 2019 01:15:28 GMT

In a chart, you could add a dimension as:

=left([Class Code],2)

Or do the same in the script to derive a new field.

-Rob