topic Re: Re: One condition and one formual in same expression in Pivot Table in QlikView

One condition and one formual in same expression in Pivot Table

Wed, 23 Oct 2013 23:37:10 GMT

HI guys,

My pivot table looks like this

What I need is this:

1. I need to hide GroupItem and GroupItemEnd Row

2. I need to make sure that Memo column should not show any value for "Total" Row.

I would like to use RowNo() instead of dimensionality() because dimensions may change for my report.

Regards,

Saurabh

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 04:52:58 GMT

In Dimension tab,

you have an option to set a condition for each dimension.

You can assign it to a variable with value 1 and assign it a value 0.

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 05:48:10 GMT

can you please give an example?

Re: One condition and one formual in same expression in Pivot Table

sushil353 — Thu, 24 Oct 2013 05:51:31 GMT

Hi,

to remove dimension value..

use if condition in dimension tab as

if (Itemtype='GroupItemEnd',null(),itemtype)

also check the option for supress null values.

HTH

Sushil

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 05:53:07 GMT

I have just attached the image...

you may have a look at it to understand my requirement. meanwhile I will try your suggestions.

Thanks.

Re: One condition and one formual in same expression in Pivot Table

jonathandienst — Thu, 24 Oct 2013 05:55:10 GMT

If I understand you correctly, then this should work:

Sum(<ItemType-={'GroupItemEnd'} If(RowNo()<>0 and not IsNull(RowNo()), Memo))
+
Sum({<ItemType-={'GroupItemEnd'}>}Memo)

But better still would be:

If(Dimensionality = 0, 0, Sum({<ItemType-={'GroupItemEnd'}>}Memo))

HTH

Jonathan

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 06:46:53 GMT

Hi Jonathan,

It is not working....

I have attached the image and also the qvw file.

See if it can help you give me a solution.

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 07:00:23 GMT

Hi Sushil,

Unfortunately it is not working.

I have chnaged the description of my problem and also have attached a the QVW file if it can help you.

Saurabh

Re: Re: One condition and one formual in same expression in Pivot Table

sushil353 — Thu, 24 Oct 2013 07:13:26 GMT

Hi,

Please find attached..

HTH

Sushil

Re: Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 07:17:50 GMT

PFA

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 07:25:39 GMT

Thanks, It works

Re: One condition and one formual in same expression in Pivot Table

Thu, 24 Oct 2013 07:26:20 GMT

Thanks, it works too.

I made Sushil's answer correct because i got his reply before.