topic Re: Pivot Chart - Conditional Expression in QlikView

Pivot Table - Conditional Expression

Anonymous — Thu, 16 Jun 2016 08:18:03 GMT

Is there a way to condition an Expression column in a Pivot Table so that it only shows when a particular Dimension is expanded?

Re: Pivot Chart - Conditional Expression

susovan — Thu, 16 Jun 2016 08:45:24 GMT

Hi,

Its might be work.

"SubStringCount(Concat(Heading, '|'), 'Field name')"

Write down this above expression in below mentioned place.

Re: Pivot Chart - Conditional Expression

Anil_Babu_Samineni — Thu, 16 Jun 2016 08:54:35 GMT

Yes Your query looking like sub Total. I am not sure

Anyway, Can you please share me the Sample Application

Re: Pivot Chart - Conditional Expression

Anonymous — Thu, 16 Jun 2016 08:56:55 GMT

Apologies, I meant Pivot TABLE not Chart. I've amended the original post.

Re: Pivot Chart - Conditional Expression

susovan — Thu, 16 Jun 2016 09:05:19 GMT

Yes, it also possible in Pivot table.

Re: Pivot Table - Conditional Expression

sunny_talwar — Thu, 16 Jun 2016 09:39:46 GMT

You might be able to use Dimensionality() or SecondaryDimensionality() function to do this. For exact expression to be used, you will need to provide more details about the number of dimensions you have and when the particular dimension should be visible and when should it be not visible. Would you be able to share a sample may be?