Re: Prob in Bar Chart in QLiksense - Qlik Community

nikhilgarg · ‎2018-01-09

Hello All,

In my qliksense, i ahve created a bar chart for Cur Yr and Prev Yr sales. But when i hover on any bar, it is showing other yr value as 0. Can anyone tell em how to suppress this?

Thanks,

Nikhil garg

Anonymous · ‎2018-01-09

Have you included cur Yr sales as another measure? Try that expression and check whether it is giving some value other than 0

Chanty4u · ‎2018-01-09

take a copy of chart and

delete one measure and check once and delete other and keep first and see.

and change the chart to straight table and see how the values look like?

devarasu07 · ‎2018-01-09

Hi,

Try below ways,

1) suppress null or 0 value from your chart object (fyi, uncheck below check box from your year and measure field)

2) by using set analysis method exclude those Sales 0 year value from chart list

let say example,

for current year sales

sum( {$<Year={"$(=Max(Year))"}, Sales={">0"}>} Sales)

for previous year

sum( {$<Year={"$(=Max(Year)-1)"}, Sales={">0"}>} Sales)

3) if your going to show in your bar always selected year and previous year then just use above two expression.

ThanksDeva

nikhilgarg · ‎2018-01-09

Hey,

1: Include Null values is already unchecked.

2: Set analysis didnt worked as expected.

Any other way?

nikhilgarg · ‎2018-01-09

Yes,

I ahve 2 measures:

curYrSales: LEt say value 100

PrevYrSales: Let say value 150

Now, if i hover on prev year, i got to see CurYr =0 and PrevYr = 150

aNd same for curYr. Any solution to this?

nikhilgarg · ‎2018-01-09

HEy,

Problem is i am using Pivot table. ANd in pivot table, we dont have background color option in dimension

I cann't use straight table because, i ahve to dynamically name my measures as:

1: Sales' $(=Only(Year)-1) and this function will only evaluate in Pivot Table.

ANy other option?

Anonymous · ‎2018-01-09

But, you have mentioned the problem is with hover in bar chart. Right?

How did pivot chart come to picture?

nikhilgarg · ‎2018-01-09