topic pivot exclude in QlikView

pivot exclude

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have Country { India, UK, US, Japan}. In pivot chart I have added country column as a Dimensions. I want to exclude 'Japan' value.

Now pivot shows:

India 50

UK 70

US 40

Japan 90

Total 250

It should show

India 50

UK 70

US 40

Total 160

Please help

surendraj — Wed, 08 Feb 2017 11:34:07 GMT

In expressions

Sum({<Country-={'Japan'}>}value)

Anil_Babu_Samineni — Wed, 08 Feb 2017 11:36:56 GMT

May be you can use in Script

Directory:

Load * Inline [

Country, sales

India, 50

UK, 70

US, 40

Japan, 90

Total, 250

];

Load Country, sales Resident Directory where Country <> 'Japan';

Or Object is this formalities

Dim as Country

And expression

Sum({<Country -= {'Japan'}>}sales)