topic Re: Displaying value in total, but removing from dimension. in QlikView

Displaying value in total, but removing from dimension.

retko1985 — Mon, 09 Apr 2018 07:55:56 GMT

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.

Re: Displaying value in total, but removing from dimension.

tresB — Mon, 09 Apr 2018 09:20:08 GMT

What is your exact expected output?

Re: Displaying value in total, but removing from dimension.

HarishG — Mon, 09 Apr 2018 11:02:36 GMT

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

Re: Displaying value in total, but removing from dimension.

stabben23 — Mon, 09 Apr 2018 11:39:52 GMT

Try With this expression

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