Having clause in setanalysis

[debsahoo]

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]

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)

[tresesco]

May be like:

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

[debsahoo]

Thank you all.

[devarasu07]

Hi,

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

[debsahoo]

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

[devarasu07]

how to close an answered thread ?

Qlik Community Tip: Marking Replies as Correct or Helpful