topic Re: Aggr & Set Expression Problem in QlikView

Aggr & Set Expression Problem

robinrouleur — Fri, 28 Feb 2014 01:52:04 GMT

I've been struggling with this for a while so I'm hoping someone can help?

I have a simple table dataset with multiple rows for each ID. I want to produce a table chart with the rows for each ID aggregated into one based on a simple expression. I can do this with Aggr but when I try to add a Set Expression to, for example, execute over the whole data set rather than the current selection, it doesn't work. The chart expression is "OK" but I get a red underline which suggests something is wrong. Here's a couple of screenshots, with and without the set expression. Am I missing something? Is this the correct/best way to achieve my objective? Phrase_Sentiment is numeric, the three "Cat_" are string dimensions (single field, not calculated).

Re: Aggr & Set Expression Problem

chiru_thota — Fri, 28 Feb 2014 02:38:39 GMT

Can you see to use below expression for your requirement ?

Note : you can add dimensions which ever you don't need to the report and hide them.So that Total will work fine.

Re: Aggr & Set Expression Problem

robinrouleur — Fri, 28 Feb 2014 06:14:43 GMT

Thanks, it's not what I wanted but it started me thinking and I realised that my brain mustn't have been working last night, I don't need the Aggr function at all !! Problem solved.

Re: Aggr & Set Expression Problem

mahesh_agrawal — Fri, 28 Feb 2014 06:21:36 GMT

Hi,

Try this one.

aggr(sum({1}Phrase_sentiment),Cat_Class,Cat_Category,Cat_SubCategory)

Re: Aggr & Set Expression Problem

er_mohit — Fri, 28 Feb 2014 06:36:05 GMT

write

sum({1} phrase_sentiment)