Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
andreyfcdk91
Creator
Creator

Group by two dimensions

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!

1 Solution

Accepted Solutions
PradeepReddy
Specialist II
Specialist II

Use the both the dimensions in group statement..

ex:

Group By Spoint,ProductType;

View solution in original post

3 Replies
PradeepReddy
Specialist II
Specialist II

Use the both the dimensions in group statement..

ex:

Group By Spoint,ProductType;

View solution in original post

its_anandrjs

Then write like

Join

Load

  Spoint,

  ProductType,

  Date(Max(Date))

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

avinashelite

Hi,

Please find the attachment for the solution.