topic Re: Issue in pivot Table in QlikView

Issue in pivot Table

vipin_mishra479 — Wed, 16 Jul 2014 18:33:06 GMT

Hi All,

I have create a pivot table and showing data subtotal wise

but i want to apply some condition please tell how can i do this.

Here i attached 1 screen shot image of pivot table here i highlight 1 subtotal which i don't want to show other than i want show please look into this.

Re: Issue in pivot Table

rbecher — Wed, 16 Jul 2014 18:47:26 GMT

Hi Vipin,

this very depends on your data and aggregation expressions. Please upload a sample app.

- Ralf

Re: Re: Issue in pivot Table

vipin_mishra479 — Wed, 16 Jul 2014 19:04:36 GMT

Hi Ralf,

PFA

Re: Re: Issue in pivot Table

rbecher — Wed, 16 Jul 2014 19:10:44 GMT

I guess you can only suppress the whole NULL segment:

Check on Dimension Segment: Suppress When NULL..

- Ralf

Re: Re: Issue in pivot Table

vipin_mishra479 — Wed, 16 Jul 2014 19:15:18 GMT

No i want to show null value but i don't want to show null total..... how can i do this..

Re: Re: Re: Issue in pivot Table

kuba_michalik — Wed, 16 Jul 2014 19:25:55 GMT

That's a bit of a wildshot (I can't view your app right now), but maybe wrapping your expression in something like:

If(Dimensionality()=2 and IsNull(Only(Segment()),0,<OriginalExpression>)

and enabling "Suppress zero rows" would help? This should (in theory) zero out all totals for null segment, and then Suppress zero would take care of hiding them.

Re: Re: Issue in pivot Table

rbecher — Wed, 16 Jul 2014 19:32:07 GMT

Wow, interesting approach. This seems to work:

=If(Dimensionality()=2 and IsNull(Only(Segment)),0,Sum(Amount))

..maybe to be sure use this:

If(Dimensionality()=2 and IsNull(Only(Segment)),Null(),Sum(Amount))

Re: Re: Re: Re: Issue in pivot Table

vipin_mishra479 — Wed, 16 Jul 2014 19:52:14 GMT

Hey Jakub,

How can I hide last 2 total.

I have attached the application.

Re: Re: Re: Re: Issue in pivot Table

vipin_mishra479 — Wed, 16 Jul 2014 19:58:06 GMT

Solve Its Thanks Guy's