Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

Hi,

Please find attached..

HTH

Sushil

View solution in original post

11 Replies
Not applicable
Author

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
Author

can you please give an example?

sushil353
Master II
Master II

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
Author

I have just attached the image...

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

Thanks.

jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

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
Author

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
Master II
Master II

Hi,

Please find attached..

HTH

Sushil

Not applicable
Author

PFA