Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I load specific rows using expressions in qlikview? For example, I have 2 columns in my excel which are LEVEL1 and LEVEL2. I want to load the rows as Level4 rows.
Currently im doing something likw the code below to get 16.29, 16.31 and 16.30 from LEVEL2 and the rest of LEVEL1 to be loaded as LEVEL4.
IF(LEVEL2 = '16.29', LEVEL2, IF(LEVEL2 = '16.31', LEVEL2, IF(LEVEL2 = '16.30'), LEVEL2, LEVEL1))) AS LEVEL4,
Is there a simpler way to do this? I need a simpler way because if i want to load more LEVEL2 specific rows, it will get complicated. Thanks
The Level3 length check is only when LEVEL2 = 16.30? or is it also for when LEVEL2 = 16.29 or 16.31?
Im sorry. I have made the adjustments. There is no LEVEL3.
Try like this in that case:
If(Match(LEVEL2, '16.29', '16.30', '16.31'), LEVEL2, LEVEL1) as LEVEL4
Thank you very much sir!