Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bharatkishore
Contributor III

Bar Chart

Hi All,

I have an Bar Chart and written the following expression:

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

>}[CM Hours])/SUM({<MonthYear={'>=$(=MonthStart(vCurrYear_SelectedMnth, 1-NUM(Month(vCurrYear_SelectedMnth))))<=$(=vCurrYear_SelectedMnth)'}

>}[CM NORM Hrs]),'#,##0.0%').

The problem what i am facing is for example:

In month year i have data from Jan to Dec. Now which ever month is selected the data should be showed like

Jan - CM hours CM Norm HRs

          10               30

Feb-    20               40

Mar-    30               50

Now if i select march data should be for March is 10+20+30/30+40+50 but i am getting as 10/30 for Jan , 20/40 for Feb , 30/50 For March.

When i take it in seperate  text box i am getting correct data. Now In graph i m not getting correct values. Can you please tell me where i am missing.

The dimension is =IF(GetFieldSelections(MonthYear)>= MonthYear, DATE(MonthYear,'MMM-YY'))

Thanks,

Bharat