topic Re: Last 3 months calaculation in QlikView

Last 3 months calaculation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

when am using month_year as dimension in the basic view backward stock coverage volume showing correct but when am using the month name as a dimension in the above chart of basic view Backward stock coverage volume showing different value,

can you please help me out on this

please find the attached application

Regards,

Devendar

Re: Last 3 months calaculation

florentina_doga — Tue, 12 Jul 2016 14:24:56 GMT

in first chart is month

in second is month year

if in first add year as dimension, value is ok

Re: Last 3 months calaculation

florentina_doga — Tue, 12 Jul 2016 14:30:58 GMT

in the first graph aggregation is done at month without taking into account the year

Re: Last 3 months calaculation

Anonymous — Tue, 12 Jul 2016 14:40:32 GMT

the requirement should be Month as dimension in the first chart and backward stock volume should be match with the second chart

Re: Last 3 months calaculation

vishsaggi — Tue, 12 Jul 2016 15:38:32 GMT

I am not sure how your data model is designed. But i can see that Month Name and Month_Year are coming from qvd inside the calendar table respectively. Just check your Month_Year expression in the edit script of your calendar tab and try adding another column [Month Name] using the same Month_Year expression like

Date(MonthStart(Date),'MMM-YYYY') as Month_Year

Date(MonthStart(Date),'MMM') as [Month Name].

Comment the Month Name used in the first few lines of the script and use this New MonthName field in your chart and try.

Just my guess the problem is there. If not I am sorry this was just my thought.

Thanks,
V.

Re: Last 3 months calaculation

Anonymous — Tue, 12 Jul 2016 15:57:04 GMT

thank you for replay, i tried this one before but same values are getting nothing is difference