topic Re: Columns to change in QlikView

Columns to change

priyarane — Thu, 09 Mar 2017 14:03:51 GMT

Hi Community,

I have data like,

and I want the out in seperate column like if Val = 'E' and it dim value should come like sum(C) as C

for Ex:

aarkay29 — Thu, 09 Mar 2017 14:09:14 GMT

Hi Priya,

further question! so if value is E then, do you want to sum up the values for E or rename the value as sum(Value) ??

avinashelite — Thu, 09 Mar 2017 14:11:08 GMT

could you post a better example??

nitin_01 — Thu, 09 Mar 2017 14:18:00 GMT

Hi Priya,

Its confusing for us to understand, please post d desired output in tabular form or in a comprehensive way to understand us.

Regards,

Nitin.

priyarane — Thu, 09 Mar 2017 14:21:20 GMT

No, I am not sum up the values I just need name like sum(C) As A so this one I will use in other select statement to sum up.

Concat(Dim1,',') as select list

and I will create variable

Let vSelectList= peek('Select_List',0,'Temp_SelectList');

And variable I can use in select statement.

aarkay29 — Thu, 09 Mar 2017 14:25:06 GMT

May be this

If(Val='E','Sum('&Val&') as '&Val,Val) as Dim1

avinashelite — Thu, 09 Mar 2017 14:25:39 GMT

still not clear ...you could try with the inline table to get the desired format