topic Re: Expression of Straight Table in QlikView

Expression of Straight Table

tyagishaila — Wed, 11 Mar 2015 05:52:26 GMT

Hi,

How can we apply group by in expression?

Thanks

PrashantSangle — Wed, 11 Mar 2015 05:56:31 GMT

Hi,

Use AGGR()

Regards

robert_mika — Wed, 11 Mar 2015 06:06:01 GMT

Example:

tyagishaila — Wed, 11 Mar 2015 06:07:55 GMT

Hi max,

Thanks for reply,

but please explain more, not clear yet.

Suppose I have following SQL group by query, How it can write as an expression in QV.

select GenericArticle,BU,Department,Stroke,Colour,CW_WHStock,LW_WHStock from dbo.MCStockAvailability

group by GenericArticle,BU,Department,Stroke,Colour,CW_WHStock,LW_WHStock

jonathandienst — Wed, 11 Mar 2015 06:26:21 GMT

Your SQL statement is another way of writing a SELECT DISTINCT. You can also use Distinct in Qlikview like

Count(Distinct GenericArticle)

HTH

Jonathan

Anonymous — Wed, 11 Mar 2015 08:15:53 GMT

if u hav month and sales columns....

Aggr(Sum(sales), month) gives mnthly sales which equal to sum(sales ) group by month in sql.....