Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load specific rows using expressions

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

4 Replies
sunny_talwar

The Level3 length check is only when LEVEL2 = 16.30? or is it also for when LEVEL2 = 16.29 or 16.31?

Not applicable
Author

Im sorry. I have made the adjustments. There is no LEVEL3.

sunny_talwar

Try like this in that case:

If(Match(LEVEL2, '16.29', '16.30', '16.31'), LEVEL2, LEVEL1) as LEVEL4

Not applicable
Author

Thank you very much sir!