Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

exception in expression

Hi,

pls help.

I have a simple pivot table with two dimensions (year,month) and to expression i need to say:

load all sales for dimension named "location",where is "3" and without data of IBM as i supplier 

Sum

({<Location={'3'},Supplier<>{'IBM'}>}(Sales))

It doesnť work because of <>,but i don´t know why and i neet to know another way how do this exception in expression

Thx a lot

Jerry

1 Solution

Accepted Solutions

Re: exception in expression

HI

Sum

({<Location={'3'},Supplier-={'IBM'}>}(Sales))

Hope it helps

1 Reply

Re: exception in expression

HI

Sum

({<Location={'3'},Supplier-={'IBM'}>}(Sales))

Hope it helps

Community Browser