topic Bar Chart - Value Mismatches in App Development

Bar Chart - Value Mismatches

d_prashanthredd — Mon, 03 Jul 2017 13:16:37 GMT

Hi,

I have one bar chart and pivot table for the same data.

I'm trying to prepare generic bar chart and pivot table, for that I have created a list view to select a particular dimension.

Once user select the dimension from the list then the bar chart and pivot table should display data accordingly. For me everything is working fine other than one default case.

List view is consisting of 'Year', 'Quarter', 'Month'

Bar Chart and Pivot table created with 2 dimensions and one measure.

1st Dim:

if(GetSelectedCount(FieldValue) = 0, Month,

if(GetFieldSelections(FieldValue) = 'Year', RHFisYear,

if(GetFieldSelections(FieldValue) = 'Quarter', RHQuarter,

if(GetFieldSelections(FieldValue) = 'Month', Month)

)

2nd Dim: if(Team = 'Global Serv Mktg', 'GSM', if(Team = 'Mkt-Ops', 'MO', Team))

Measure: $(vUtilizationHrs)/($(vAvailableHrs))

vAvailableHrs:

Sum(TOTAL <[Date Entered],Resource, Team, Month, Quarter, RHQuarter>

Aggr(NetWorkDays (Date#(Min(date([Date Entered],'M/D/YYYY'))),Date#(max(date([Date Entered],'M/D/YYYY')))),

Resource, Team, RHQuarter, Month, Quarter)*8) -

sum(TOTAL <[Date Entered],Resource, Team, Month, Quarter, RHQuarter>aggr(sum(if(IsHoliday = 'Y', '1', 0))*8,Resource, Team, RHQuarter, Month, Quarter))

vUtilizationHrs:

Sum([Utilization (In Hrs)])

Requirement:

If nothing has selected from list view, by default it should consider 1st dim as Month (Ref above expression) and if something has selected, reports should display accordingly.

Issue:

By default my bar chart is displaying values (5 times to expected value) but pivot is displaying accurate.

If i select month or any other list value, then the values are displaying correct.

I don't know why default value (month) showing 5 times than when I select month from list.

By Default:

When I select Month:

Note: Ignore the label name Year, label should be Month.

Can anyone help me in understanding the issue.

Thanks & Regards,

Prashanth Reddy D.

Re: Bar Chart - Value Mismatches

sunny_talwar — Wed, 05 Jul 2017 12:16:52 GMT

Would you be able to share a sample to look at this? I know you have laid out all possible description, but looking at the issue might help us understand better

Re: Bar Chart - Value Mismatches

d_prashanthredd — Wed, 05 Jul 2017 13:26:26 GMT

Hi Sunny,

Have a look at the bar and other charts. I can see the difference only if

nothing has selected from list view. i.e. By default, I'm building charts

by Quarter.

On Wed, Jul 5, 2017 at 5:47 PM, Sunny Talwar <qcwebmaster@qlikview.com>

Re: Bar Chart - Value Mismatches

d_prashanthredd — Wed, 05 Jul 2017 13:27:37 GMT

My app is huge, just for the sake of issue, I built new one.

Re: Bar Chart - Value Mismatches

sunny_talwar — Wed, 05 Jul 2017 16:41:45 GMT

I am not sure why this is happening, but this is a work around

Sum(Aggr($(vUtilizationHrs), Team,

$(=if(GetSelectedCount(MesValue) = 0, 'Quarter', if(GetFieldSelections(MesValue) = 'Year', 'RHFisYear', if(GetFieldSelections(MesValue) = 'Quarter', 'Quarter', if(GetFieldSelections(MesValue) = 'Month', 'Month', 'Quarter')))))))/($(vAvailableHrs))

Re: Bar Chart - Value Mismatches

d_prashanthredd — Thu, 06 Jul 2017 06:40:28 GMT

Hi Sunny,

Thanks a lot.. It is working.

How can I bring that issue to QlikDev Team?

Re: Bar Chart - Value Mismatches

sunny_talwar — Thu, 06 Jul 2017 11:30:34 GMT

I am not sure, but may be mto‌ can help here

Re: Bar Chart - Value Mismatches

Michael_Tarallo — Thu, 06 Jul 2017 16:08:50 GMT

Hi Prashanth - you can send an email to support@qlik.com - please make sure to reference this thread as well as provide any repro steps to reproduce the issue.