Conditional "total"

[#1]

Hi all,

My QVW file is attached.

In the file you'll see that only the 2nd order has the value of "subTitle".

The requirement is that if the field "subTitle" has value, then show the partial sums, otherwise, don't show the partial sums.

Can and how the QlikView archieve this requirement?

Thanks and best regards,

CoCo

[NareshGuntur]

No problem. I guess you are missing something.

May be I can help you if you can share the updated qvw(where you have already tried the script which I have given)

[#3]

After I used the "=if(Test = 'subTitle', subTitle, if(Len(subTitle)>0, Test))", what I got like this:

[#4]

Ok, Thanks.

[NareshGuntur]

Oh OK.

You need to suppress the Null values for the dimension subTitle(3rd dimension).

Cheers,

Naresh

[#6]

Oh, great!

Thanks a lot.

But how can I set the "Total" text in bold style just like that in your qvw file?

[NareshGuntur]

Hi CoCo,

Expand the Dimension(the '+' symbol) and in Text Format update the following.

=if(Test = 'Total','<B>')

Cheers,

Naresh

[#8]

Hi Naresh G,

Thank you too much.

Cheers,

CoCo