Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

PIVOT GET the max date for each month (set analysis or aggr?)

cannot figure out how to get the max date for each month selected and the tot sum of stock:

FOR each id_code (in the example there is only one id_code) I would like to get the stock at the maximum date available for the selected months

+ the max value , min value , avg over the period;

(the TEST chart works only is one month is selected.... which is not what I want)

error loading image

Tags (3)
2 Replies
martin59
Valued Contributor II

Re. :PIVOT GET the max date for each month (set analysis or aggr?)

Hello,

Look at the attached file.

Martin

Not applicable

Re. :PIVOT GET the max date for each month (set analysis or aggr?)

GREAT!!!!!

THANK YOU

Alex

Community Browser