Expression of Straight Table

[tyagishaila]

Hi,

How can we apply group by in expression?

Thanks

[PrashantSangle]

Hi,

Use AGGR()

Regards

[robert_mika · Accepted solution]

Example:

Group by within an Expression

[tyagishaila]

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]

Hi

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]

if u hav month and sales columns....

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