topic Re: Combo Chart % Change Missing Value in QlikView

Combo Chart % Change Missing Value

Fri, 11 Apr 2014 11:46:04 GMT

Hi all,

I have a basic combo chart with two expressions Sum() and Column(1) / Above(Column(1)

Is it possible to adjust the expression so that it draws the line from the begging and shows the % change of the first bar?

Thanks,
Ivelin

Re: Combo Chart % Change Missing Value

Gysbert_Wassenaar — Fri, 11 Apr 2014 11:57:08 GMT

Nope, there is no bar before the first bar so the expression cannot be calculated for the first bar. The % of change for the first bar doesn't exist. There was no bar before the first bar in the chart and therefore no change.

What you can do instead is calculate the change in the script. See attached example.

Re: Combo Chart % Change Missing Value

arjunkrishnan — Fri, 11 Apr 2014 12:01:18 GMT

Hi Lvelin,

I make Little Changes In Ur App ...

Look Now It's Ok or Not

Lets Find My AttachMent

Re: Combo Chart % Change Missing Value

Fri, 11 Apr 2014 12:15:11 GMT

In your combo chart you are using Sum() and Column(1) / Above(Column(1) these 2 expressions.

So for the second exprssion ur using above function.Above function takes the value from previous row. For first bar there won't be any previous value so it will be null(-).

Hence its not showing the % change of first bar.

Re: Combo Chart % Change Missing Value

Fri, 11 Apr 2014 12:26:22 GMT

Is there a different expression which can do the same job? Doesn't have to be Column(1) / Above(Column(1) per se

Re: Combo Chart % Change Missing Value

Gysbert_Wassenaar — Fri, 11 Apr 2014 12:40:57 GMT

If you really want you can use this:

Column(1) / if(RowNo()>1, Above(Column(1)), $(=sum({<date={20140101}>}value)) ) -1

Re: Combo Chart % Change Missing Value

Fri, 11 Apr 2014 12:47:05 GMT

For the first row take the same value as column 1, otherwise use the same expression of above.

Like,

Column(1) / if(RowNo()>1,Above(Column(1))-1,Column(1))

Hope this will help you.!