Prob in Bar Chart in QLiksense

[nikhilgarg]

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

[nikhilgarg]

HEy,

Pls find the expressions as below:

1: For Cur Year Sales:

=

if(vYTD = 1,

Sum({<Year = {'$(vCurYear)'}, MonthNumber = {'<=$(=vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)/10000000,

Sum({<Year = {'$(vCurYear)'}, MonthNumber = {'$(vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)/10000000

)

1: For Prev Year Sales:

if(vYTD = 1,

Sum({<Year = {'$(vPrevYear)'}, MonthNumber = {'<=$(=vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)/10000000,

Sum({<Year = {'$(vPrevYear)'}, MonthNumber = {'$(vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)/10000000

)