filter on column of pivot table

[#1]

Hi guys,

I got one filter table which looks like this

I need to filter out GropupItemEnd and - values and also need to hide the sum(amount) of these values.

I tried changing the ItemType dimnsion like

=if(ItemType<>'GroupItemEnd', ItemType)

so it hides the GrouptItemEnd but adds the sum(amount) of GroupitemEnd to the "-" row like this

And the title of this column is changed to the expression which i do not want.

Here is the attached QVW.

[Aurelien_Martinez · Accepted solution]

Hi,

try this expression:

Sum({<ItemType-={'GroupItemEnd'}>} amount)

[MayilVahanan]

Hi

I didn't see any data in your file.

Any way try like this

Sum({<ItemType-={'GroupItemEnd'}>} amount)

And  in dimension -> Suppress When Value is Null

[#4]

Qliview detects syntax error

Sum({<ItemType-={'GroupItemEnd'}>} amount)

it does not give syntax error if use = and not -=

[#5]

Qliview detects syntax error

Sum({<ItemType-={'GroupItemEnd'}>} amount)

it does not give syntax error if use = and not -=

[#6]

I just found that even it works even if it gives syntax error.

Though it works in my test qvw and not in real env but i will figure that out.

Thanks.

[MayilVahanan]

Hi

Its not syntax error, actually its bug in qlikview