topic Re: Division in bar chart in QlikView

Division in bar chart

bharatkishore — Thu, 28 Sep 2017 06:16:03 GMT

Hi All,

I have a bar chart and written the following expression :

=Num(SUM({<MonthYear ={'>=$(=MonthStart(vCurrYear_SelectedMnth, 1-NUM(Month(vCurrYear_SelectedMnth))))<=$(=vCurrYear_SelectedMnth)'} >}[Strategic consumption]),'###0.0')/month(monthyear)

In bars i have data from Jan to July and this division value is only showing for one month. Now how can i show for all the months.

Can you please tell me is there anything i have to change the expression.

Thanks,

Bharat

Re: Division in bar chart

PrashantSangle — Thu, 28 Sep 2017 06:35:09 GMT

can you provide sample file or provide screen shot of what you tried and what you are getting?

Regards,

Re: Division in bar chart

bharatkishore — Thu, 28 Sep 2017 07:07:41 GMT

Hi Prashanth,

Pls find the attached qvw and you can see there only for july i can see exp1 data but i want to see for all the months..

Re: Division in bar chart

PrashantSangle — Thu, 28 Sep 2017 08:16:47 GMT

change month(MonthYear) to num(month(MonthYear))

sum({<MonthYear=>} InsallBase) to sum(Total InsallBase)

Regards,

Re: Division in bar chart

bharatkishore — Thu, 28 Sep 2017 08:28:23 GMT

Hi Prashant,

I have given the following expression:

=Num(SUM ({<MonthYear={'>=$(=MonthStart(vCurrYear_SelectedMnth1, 1-NUM(Month(vCurrYear_SelectedMnth1))))<=$(=vCurrYear_SelectedMnth1)'}

>}InstallBase),'###0.0')/num(month(MonthYear))

but still it is not working.. It is showing for one month.

Re: Division in bar chart

PrashantSangle — Thu, 28 Sep 2017 08:58:52 GMT

This is because you are selecting monthyear

that's why you are getting it for one.

Regards,