Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Expression of Straight Table

Hi,

How can we apply group by in expression?

Thanks

1 Solution

Accepted Solutions

5 Replies

Hi,

Use AGGR()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Specialist
Specialist

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator
Creator

if u hav month and sales columns....

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