Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All, Need your help on below query. I have two dimensions in the data, I need to get them in one dimension in qlik view. The output shown below. Your help is great appreciated. Regards
Data
Dimension1 Dimension2 Sales
Parent 1000
Child1 230
Child2 234
Child3 450
Qlik view output should be
Dimension Sales
Parent 1000
Child1 230
Child2 234
Child3 450
Note: I do not want to use IF function here since that slows down the calculation speed.
hi
may be this will help you .
Thanks for this Venkatesh. Actually I did not give the clear data structure. Please find below the data and the output I am trying to achieve. Your help is much appreciated.
Data | ||
Dimension1 | Dimension2 | Sales |
Parent | 1000 | |
Child1 | 230 | |
Child2 | 240 | |
Child3 | 320 | |
Child4 | 457 | |
Child5 | 84 | |
Child6 | 544 | |
Child7 | 141 |
Output | |
Dimension | Sales |
Parent | 1000 |
Child1 | 230 |
Child2 | 240 |
Child3 | 320 |
Child4 | 457 |
Child5 | 84 |
Child6 | 544 |
Child7 | 141 |
Thanks Vishal. But Can this be done with expression which should not lead to performance issue? Usually IF function is good for this but IF function slows down the performance. I have huge records in the QVD.
Solution with Expression would be very helpful please.