Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
chinnukool
New Contributor III

Year & Values in Bar chart and Staright table DONOT match when a selection is made in staright table

Hi,

I have a Bar chart and a straight table displaying same data.

when I make selection in straight table, the values in the bar chart are not matching with straight table.

In below screenshot, Bar chart has 0.83 for 2014 where as straight table has that value for 2015.

When I don't make any selections in Straight table both charts are matching.Attached is the qvw.

Can someone please help me ASAP. Thanks!

Tags (4)
3 Replies
Highlighted
mwoolf
Honored Contributor II

Re: Year & Values in Bar chart and Staright table DONOT match when a selection is made in staright table

Your table expression for 2015 is:

=(sum({<Year= {$(=Max(Year)-1) },SPENDTYPE -= {'ARIBA'}>}SPEND/1000000))

but the label for that expression is:

=Max({1}(Year)-1)

The label is ignoring selections (giving 2015), but the expression is not ignoring selections (giving the sum for 2014).

Perhaps change your expressions to match the labels:

=(sum({<Year= {$(=Max({1}Year)-1) },SPENDTYPE -= {'ARIBA'}>}SPEND/1000000))

chinnukool
New Contributor III

Re: Year & Values in Bar chart and Staright table DONOT match when a selection is made in staright table

Looks like it is working, but I have noticed another issue.

When I select a name in straight table, I see data for 4years in straight table but in Bar chart I see data only for 3years.

I have to fix this today, Can someone please help me ASAP. I have attached the qvw to the original discussion. Thanks!

Highlighted
chinnukool
New Contributor III

Re: Year & Values in Bar chart and Staright table DONOT match when a selection is made in staright table


Hi m w,

I tried changing expressions to match the labels and it didn't work. It fixed 2014 numbers but now I see ame issue with 2015 & 2016 numbers. Can you please help me fix this. Thanks!

In below screenshot, Bar chart has 0.01 for 2016 where as straight table has that value for 2015.