topic Re: Having clause in setanalysis in QlikView

Having clause in setanalysis

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

HELLO,

I have a table which have product name and sales.

Requirements is- In a chart show the sum of sales product wise. Where the product's sum of sales between 10,000 and 20,000.

Plz help me to write setanalysis.

Thanks in advance.

devarasu07 — Mon, 18 Dec 2017 12:16:33 GMT

Hi,

try like this

Fact:

LOAD * INLINE [

Product, Sales

A, 3000

B, 6000

C, 10000

D, 15000

E, 20000

F, 25000

];

create measure using set analysis

sum( {$<Sales= {">=10000<=20000"}>}Sales)

tresB — Mon, 18 Dec 2017 12:17:00 GMT

May be like:

=Sum({<Product={"=Sum(Sales)>=10000 and Sum(Sales)<20000"}>}Sales)

debsahoo — Mon, 18 Dec 2017 18:34:53 GMT

Thank you all.

devarasu07 — Mon, 18 Dec 2017 18:39:22 GMT

Hi,

Help us to close this thread by marking as correct.it might useful for others who is having similar issue. thanks

debsahoo — Mon, 18 Dec 2017 19:13:05 GMT

I am new in qlikview. can you tell me how to close thread or check as current answer.

devarasu07 — Mon, 18 Dec 2017 19:14:49 GMT