Problem in Chart Computation

[manpri7078]

Hi All,

I am attaching sample excel file as well as sample qlikview document for my query.

I have made two charts. My left chart is having calculation error which is not showing the bars of previous months as defined in the variable, whereas my right chart is working perfectly.

Actually in my Left Chart I am making expression which will pick the name from the list box by the name of Sector and accordingly calculate the expression, whereas in the right chart I have made a simple chart containing the data of Aluminium only.

Both the charts are self explanatory. May be I am doing wrong somewhere in my left chart expression.

I want your guidance where I am doing wrong.

Regards,

Manish Prasad

[arvind_patil]

Hi Manish,

Kindly find the attachment. Problem Is Because of Presentation issue.

Thanks,

Arvind Patil

[manpri7078]

Hi Arvind,

In my dashboard FY and Month will be selected. While keeping it selected right chart is showing perfectly

But problem is with the left chart.

Please see from this angle and first select 2018 from FY and Jun from Month list boxes and then guide me accordingly

Regards

Manish Prasad

[jonathandienst · Accepted solution]

The problem is because when you select a date, the possible values for Sector are null for the other months in the chart.

Change:

    Pick(Match(Sector,'Aluminium','Copper','Corporate'), ...

To

    Pick(Match(Only(TOTAL Sector),'Aluminium','Copper','Corporate'), ...

    or

    Pick(Match(Only({1<Sector = $::Sector>} TOTAL Sector),'Aluminium','Copper','Corporate'), ...

These expressions  produce all the bars for the first chart.

[manpri7078]

Hi Jonathan,

Thanks for your guidance. Now it is working perfectly.

Regards,

Manish Prasad