Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

One condition and one formual in same expression in Pivot Table

HI guys,

My pivot table looks like this

Screen Shot 2013-10-23 at 11.40.51 PM.png

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

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

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

Hi,

Please find attached..

HTH

Sushil

11 Replies
Not applicable

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

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.

Not applicable

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

can you please give an example?

sushil353
Honored Contributor II

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

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

Not applicable

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

I have just attached the image...

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

Thanks.

MVP
MVP

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

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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

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.

Not applicable

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

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

sushil353
Honored Contributor II

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

Hi,

Please find attached..

HTH

Sushil

Not applicable

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

PFA