topic Re: set analysis not work in QlikView

set analysis not work

Anonymous — Fri, 24 Apr 2015 06:23:01 GMT

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.

Re: set analysis not work

fvelascog72 — Fri, 24 Apr 2015 06:36:59 GMT

Hi,

Syntax seems ok.

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

Re: set analysis not work

Anonymous — Fri, 24 Apr 2015 06:42:16 GMT

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.

Re: set analysis not work

danieloberbilli — Fri, 24 Apr 2015 06:44:29 GMT

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

Re: set analysis not work

anbu1984 — Fri, 24 Apr 2015 06:47:08 GMT

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

Re: set analysis not work

fvelascog72 — Fri, 24 Apr 2015 06:49:17 GMT

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

To check if GROUP has sales values..

Re: set analysis not work

Anonymous — Fri, 24 Apr 2015 06:49:31 GMT

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

Thanks

BKC