topic Re: Merge heirarchy in QlikView

Merge heirarchy

gauthamchilled — Mon, 07 Dec 2015 10:47:46 GMT

I have three levels as dimension, I want to make it as single column and use it as dimension.

I attached the qvw file. I need to create a straight or pivot table with one column as dimension and other as expression

can anyone help or give suggestions to achieve this way. I don't get idea how to merge the three columns without affecting the hierarchy

Level	Expression
NET PROFIT	sum of all the level2 values(Profit+Profit+core profit)
PROFIT	SUM OF (ABC PROFIT+ DEF PROFIT)
ABC PROFIT	SUM OF ABC PROFIT
DEF PROFIT	sum of DEF PROFIT
FGH PROFIT	sum of fgh PROFIT

mohamed_ahid — Mon, 07 Dec 2015 14:28:03 GMT

hello ,

like this?

Anonymous — Mon, 07 Dec 2015 15:26:28 GMT

Hi ,

Find the attached qv file and let me know if you need anything

Regards,

Devendar

Kushal_Chawda — Mon, 07 Dec 2015 15:47:02 GMT

See the attached

gauthamchilled — Tue, 08 Dec 2015 03:11:42 GMT

Thanks Kush, But the expression is complex, if I use to calculate mtd ,qtd and ytd. Can it be simplified?

Because I have to repeat the expression for dynamic selection of qtd, mtd and ytd

Kushal_Chawda — Tue, 08 Dec 2015 05:47:58 GMT

You can use the set analysis in your expression to get the mtd ytd values. you can do it in same expression

gauthamchilled — Tue, 08 Dec 2015 06:07:24 GMT

Ok.

Is anyway I can handle this in the script instead of valuelist?

Kushal_Chawda — Tue, 08 Dec 2015 07:06:21 GMT

Yes , you can do this in script as well

See the attached