topic Month To Month Compare in QlikView

Month To Month Compare

dhanu_today — Wed, 02 Apr 2014 17:54:16 GMT

Hi Everyone,

I have the requirement below and the same has been attached below and i have to develop the same through front end because of data model.

The requirement is if am selecting the period FEB then the chart has to show the CASA products which

are opened in the previous month(like Jan-01 to Jan-31) that are in countwise say for e.g

201,402,303,502.

The second requirement in the second expression is for the 4 cust_id mentioned above we have to count the FD PRODUCT.

e.g.201,402,502 have the FD in the month of FEB .So we have to show the count as 3.

Like wise i have to show the next months also.If am selecting MARCH then CASA count should be on the basis on the CUSTID_DATE as previous month

then for those cust_ids which are having FD product in the March Month.

Thanks in adv,

Dhanu

VishalWaghole — Thu, 03 Apr 2014 04:56:27 GMT

Hi dhanu,

I gone through with your QVW file and requirement.

In your chart, you created calculated dimension, In that you only matched 'CA' and 'SA' Product.

and your second requirement is you want FD Product cound for FEB, i dont think so it is possible

cause you hardcoded 'CA' and 'SA' values in you dimension.

Please find attached file, i have add PRODUCT as dimension by removing you caluculated dimension.

but i dont know why it shows 'ZA' product for the same even you wrote set analysis only for 'CA' and 'SA'

- Regards,

Vishal Waghole

dhanu_today — Thu, 03 Apr 2014 16:58:39 GMT

Thanks Vishal.But its not filling requirement.

Any hint from anyone.

Dhanu

dhanu_today — Fri, 04 Apr 2014 17:16:44 GMT

Any help from experts... Dhanu