set analysis not work

[Anonymous]

I am trying to use set analysis expression,

but it does not work,

ıt brings the overall total , nothing changes,

what am ı doing wrong?

sum({$<GROUP={'DESKTOP'}>} SALES)

this brings the all total anyway, but ı want the desktop totals.

[fvelascog72]

Hi,

Syntax seems ok.

What do you have if you use a straight table GROUP as dimension and Sum(Sales) as expression?

[Anonymous]

I have SALE_MONTHS (yyyymm) as dimension. (trying to make bar chart)

and sum({$<GROUP={'DESKTOP'}>} SALES) expression.

ı want to see

sales filtered by 'DESKTOP' by months.

[danieloberbilli]

Are you sure that you used the correct field (GROUP?) in set analysis. If not Qlik will show the total. If it consists of 2 words, ensure you write the brackets [Group Label]   and its case sensitive

[anbu1984]

Do you all caps 'DESKTOP' in Group field? Only if case matches then you will get sum of Sales for DESKTOP group

[fvelascog72]

Could you try a straight table GROUP as dimension and Sum(Sales) as expression?

To check if GROUP has sales values..

[Anonymous]

can you share sample application if possible. It seems your data issue as syntax looks good.

Thanks

BKC