Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smitaranikr04
Creator
Creator

Last/Max Week of Previous month

Please help me to create the charts with the following requirement.

Input Sample Data:

CountryYearMonthYearWeekStock
America2013P072013W3052
America2013P072013W3163
America2013P082013W3224
America2013P082013W3315
America2013P082013W3489
America2013P082013W3517
America2013P092013W3668
INDIA2013P072013W30100
INDIA2013P072013W3154
INDIA2013P082013W3287
INDIA2013P082013W3353
INDIA2013P082013W3462
INDIA2013P082013W35300
INDIA2013P092013W3680

Requirement 1:

To show the Stock value of Last/Max Week of the Previous Month in corresponding YearMonth. For example, the value of Stock of 2013W30 should be shown against 2013P08.

Chart 1 :

YearMonthSum of stock of Previous Month's Last Week
2013P07
2013P08152
2013P09317

Requirement 2:

To show the Stock value of the Last/Max Week of the Previous Month for the curent Month ie last Week of Current Month - 1

Chart 2:

CountrySum of stock of Previous Month's Last Week
America17
INDIA300
3 Replies
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
smitaranikr04
Creator
Creator
Author

Thanks G Wassenaar

But it will be helpful if it is done in UI , as I have to apply the same logic in many scenarios *charts.

Is it possible with set analysis??

Gysbert_Wassenaar

No.


talk is cheap, supply exceeds demand