Current and Previous Month Sales Comaprison

[Anonymous]

Hi Friends,

             I have one problem ,my client requirements is sales report on basis of date filed ,suppose i selected Jan-2013

the current Month is Jan-2013 and Previous month is Dec-2012.

           i needed to display report structure like.

Date	Sales For Jan-2013	Sales For dec-2012
01-01-2013	2000	3000
02-01-2013	2500	4000
03-01-2013	2200	5000
04-01-2013	2100	2500
05-01-2013	5000	4500

what ever the Dec-2012 value are related to Dec month 01-12-2012,02-12-2012,03-12-2012,04-12-2012,05-12-2012.

same like for every month.

Please help me how to resolve the issue.

Thanks for your support.

Please find the test data for creating report,i want to calculate in UI only not is scripting part.

Thanks & Regards

SHAIK

[#2]

I would recommend using a Day field instead of the Date field you have above to avoid confusing your user.  I have attached an example using variables to define the date range.

[Anonymous]

Hi Rebecca,

           Thanks for your replay,here problem is user is asking with Date field dimensions.

   Please let me know if it is possible or not,because i want to calculate UI only not in back end scripting.

Thanks
SHAIK

[Anonymous]

Instead of Day you can use the Date field .

It will definitely work.

[Anonymous]

Hi Nitin,

        thanks for your support i tried for that one i did't get the required answer, can you please provide the test application.

above i shared the test data,

Thanks

SHAIK

[VishalWaghole]

Hi Khadar,

First go to edit script and cerate MonthName field as

MonthName(INVOICE_DT) as InvDtMonthName

then try this exression in your chart

= sum ({<Date = {"=$(=AddMonths(max(InvDtMonthName),-1))"}>}Sales)

Hope it will work for you.

- Regards,

Vishal Waghole

[tresesco]

Dear Shaik,

To resolve this sort of requirement, it is usually taken into the script and followed a well known AsOfDate way.

Doing it in the front end, would be a bit complex. Please see the attached sample.

[Anonymous]

PFA.

[Anonymous]

Hi vishal,

      thanks for your replay,i tried what ever the expression you are given,it's not working according to requirement.

if you have any other clue please let me know.

Thanks

SHAIK

[sanketkhunte]

Hi Shaik

Tell me which version of Qlikview you are using ?

If you are using 11 or onwards (SR) just create ALTERNATE STATE for current month and previous month : Check these sets in expression.

For more reference : User "What's New in Qlikview 11 - Comparative Analysis point"

Hope this will help.

Thank you

Sanket