Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
retko1985
Creator II
Creator II

Displaying value in total, but removing from dimension.

Hello,

I have a weirdly structure data, where I have a hierarchy structure, and records for higher level has nulls or NA for columns of lower level.

Now I want to create a straight table, where I will show all the values of Level2, and show value of Level1 in a total row, but not between the dimension values.

So I need to get rid of this row marked in red.

I prepared a model example in QVW, attaching.

Can someone help me with this?

Thank you.

3 Replies
tresesco
MVP
MVP

What is your exact expected output?

HarishG
Partner
Partner

Assuming your expected output is just to remove the record NA as shown in screenshot

Remove NA.png

stabben23
Master
Master

Try With this expression

if(Dimensionality()=0,
sum({<Level2 ={'NA'}>}Amount),sum({<Level2 -={'NA'}>}Amount))