topic Re: Set Expression in QlikView

Set Expression

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

How can i write this in set expression,Here my dimension is Product

sum(if(Product='Shoes',if(sales>1500,sales),sales))

Re: Set Expression

qlikview979 — Tue, 13 Jun 2017 12:23:43 GMT

Help me on this loveisfail‌vinieme12‌avinashelite‌

Regards

Re: Set Expression

sunny_talwar — Tue, 13 Jun 2017 12:30:26 GMT

May be this

Sum({<Product = {'Shoes'}, sales = {'>1500'}>}sales)

Re: Set Expression

Frank_Hartmann — Tue, 13 Jun 2017 12:31:38 GMT

try like this:

sum({<Product={'Shoes'}, sales={"=sales>1500"}>} sales)

hope this helps

Re: Set Expression

sunny_talwar — Tue, 13 Jun 2017 12:33:08 GMT

Or may be this

Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)

Re: Set Expression

qlikview979 — Tue, 13 Jun 2017 12:35:15 GMT

Hi Bro,

If condition and set expression is giving different result.

like below

Re: Set Expression

sunny_talwar — Tue, 13 Jun 2017 12:36:10 GMT

Try this

Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)

Re: Set Expression

qlikview979 — Tue, 13 Jun 2017 12:38:06 GMT

Not working what you people are provided

Re: Set Expression

vinieme12 — Tue, 13 Jun 2017 12:38:36 GMT

may be

sum({<Product={"=SUM({<Product = {'Shoes'}>}sales)>1500"} >}sales)

Re: Set Expression

vinieme12 — Tue, 13 Jun 2017 12:39:06 GMT

can you post your sample?

Re: Set Expression

qlikview979 — Tue, 13 Jun 2017 12:39:57 GMT

Not working

Re: Set Expression

qlikview979 — Tue, 13 Jun 2017 12:42:32 GMT

Hi Bro,

Product	Customer	sales
Laptop	Madhu	50000
Laptop	Ravi	70000
Laptop	Raja	1000000
Shoes	Madhu	1500
Shoes	Raja	4200
Shoes	Krishna	45000
T.V	Madhu	25000
T.V	Ravi	27000
T.V	Raja	32000
W.M	Raja	1500
W.M	Madhu	8000
W.M	Ravi	15000

Re: Set Expression

qlikview979 — Tue, 13 Jun 2017 12:44:44 GMT

Here i want to eliminate sales when product sheos sales <=1500

Re: Set Expression

antoniotiman — Tue, 13 Jun 2017 12:48:36 GMT

Sum({<Product={'Shoes'},sales={'> 1500'}>} sales)+Sum({<Product-={'Shoes'}>} sales)

Re: Set Expression

enfodavid — Tue, 13 Jun 2017 12:49:43 GMT

What are you trying to achieve mahesh? Walk us through it in words.

For example your first one I would explain as this:

Take all sales and take all sales for shoes that for each transaction that are above 1500. (So I would say a logical fault here, maybe you want to discard all sales that are below 1500 for shoes?)

sum({<Product={'Shoes'}, sales={'> 1500'}>} sales) + sum({<Product-={'Shoes'}>}sales)

Is this what you are after?

Re: Set Expression

Anonymous — Tue, 13 Jun 2017 12:52:21 GMT

SUM({<Product={'Shoes'},Sales={'>1500'}>} Sales)+SUM({<Product={'*'}-{'Shoes'}>} Sales)

Re: Set Expression

vinieme12 — Tue, 13 Jun 2017 12:54:36 GMT

then this

sum({<Product-={'Shoes'}>+<Product={"=SUM({<Product = {'Shoes'}>}sales)>1500"} >}sales)

Re: Set Expression

Frank_Hartmann — Tue, 13 Jun 2017 12:54:58 GMT

have a deeper look at sunnys solution.

for me its working with the data you provided.