topic Re: Conditional "total" in QlikView

Conditional "total"

Wed, 15 Jan 2014 07:30:51 GMT

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

Re: Conditional "total"

Wed, 15 Jan 2014 07:38:27 GMT

There is no attachment to this thread. Can you re-attach your file.

Re: Re: Conditional "total"

Wed, 15 Jan 2014 07:40:53 GMT

Oh, Sorry!

Please have a look at the attachment.

Thanks.

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 08:22:32 GMT

Hi CoCo,

As you are using Personal Edition, I 'll not share the qvw but you can add this script.

LOAD * Inline [

Test

subTitle

Total

];

In Dimension, in place of subTitle(3rd dimension), use

=if(Test = 'subTitle', subTitle, if(Len(subTitle)>0, Test))

Cheers,

Naresh

Re: Conditional "total"

Wed, 15 Jan 2014 09:08:21 GMT

Hello,

Thanks for your kind help. I tried but it didn't achieve the need.

The requirement is when the field "subTitle" has value, then calculate the partial sum.

When the field "subTitle" is null, ie, the corresponding order has only one row, then do nothing.

So how can I do? Please help me.

Best regards,

CoCo

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 09:11:59 GMT

You can have a look at the attached qvw.

Cheers,

Naresh

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 09:14:31 GMT

You need something like this if I am not wrong.

Re: Conditional "total"

Wed, 15 Jan 2014 09:23:40 GMT

Yes, right. That's just what I want.

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 09:27:32 GMT

I have done the samething in the attached qvw(in the below reply)

LOAD * Inline [

Test

subTitle

Total

];

In Dimension, in place of subTitle(3rd dimension), use

=if(Test = 'subTitle', subTitle, if(Len(subTitle)>0, Test))

Re: Conditional "total"

Wed, 15 Jan 2014 09:29:56 GMT

Oh dear, you know I'm using the Personal Edition, can't open the attached qvw file.

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 09:33:06 GMT

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)

Re: Conditional "total"

Wed, 15 Jan 2014 09:35:26 GMT

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

Re: Re: Conditional "total"

Wed, 15 Jan 2014 09:39:24 GMT

Ok, Thanks.

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 09:48:04 GMT

Oh OK.

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

Cheers,

Naresh

Re: Re: Conditional "total"

Wed, 15 Jan 2014 10:10:56 GMT

Oh, great!

Thanks a lot.

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

Re: Conditional "total"

NareshGuntur — Wed, 15 Jan 2014 10:13:55 GMT

Hi CoCo,

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

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

Cheers,

Naresh

Re: Conditional "total"

Thu, 16 Jan 2014 02:28:43 GMT

Hi Naresh G,

Thank you too much.

Cheers,

CoCo