topic Re: Group by two dimensions in QlikView

Group by two dimensions

Anonymous — Thu, 28 Aug 2014 05:51:31 GMT

Good day.

There is my model in attached file.

In load script i calculate max date, where quantity > 0 grouping by Spoits.

How can i calculate the same, but grouping by Spoints and ProductType?

Thank you!

PradeepReddy — Thu, 28 Aug 2014 05:56:17 GMT

Use the both the dimensions in group statement..

ex:

Group By Spoint,ProductType;

its_anandrjs — Thu, 28 Aug 2014 05:57:00 GMT

Then write like

Join

Load

Spoint,

ProductType,

Date(Max(Date))

Resident Input Where Quantity>0 Group By Spoint,ProductType;

avinashelite — Thu, 28 Aug 2014 06:03:22 GMT

Hi,

Please find the attachment for the solution.