topic Re: Re: Chart Query in QlikView

Chart Query

Sat, 17 May 2014 03:35:57 GMT

Hi All

I have a bar chart and have added Total at the last(from dimension limits) and now I was trying to apply bar offset to apply waterfall effect in all bar except the "Total" bar in the end and the first one

I tried the below expression but its now working

if(RowNo()<= Count(DISTINCT [City),RangeSum(Above(Sum(Sales), 1, RowNo())),0)

Re: Chart Query

MK_QSL — Sat, 17 May 2014 06:22:43 GMT

Sample Apps or Data pls !

Re: Re: Chart Query

Tue, 20 May 2014 05:39:53 GMT

Hi Manish,

Thanks for help. I have attached the sample data and chart I want to create .

I have added the formula in bar offset

if(RowNo()<=5,RangeSum(Above(Sum(Sales), 1, RowNo())),0)

I want 5 to be picked dynamically. I tried to use

if(RowNo()<= Count(DISTINCT Country ),RangeSum(Above(Sum(Sales), 1, RowNo())),0)

but its not working

Many thanks for your help and time

Re: Chart Query

jagan — Tue, 20 May 2014 05:54:51 GMT

Hi,

Try this expression

if(RowNo()<= Count(DISTINCT Country),RangeSum(Above(Sum(Sales), 1, RowNo())),0)

Regards,

Jagan.

Re: Chart Query

Tue, 20 May 2014 06:05:33 GMT

hi Jagan,

It's not working. I already tried that

Re: Chart Query

jagan — Tue, 20 May 2014 06:11:41 GMT

Hi,

Put it in a variable and refer it in the expression. It is working for me.

Regards,

Jagan.

Re: Re: Chart Query

jagan — Tue, 20 May 2014 06:13:44 GMT

Hi,

Please find attached file.

Regards,

jagan.

Re: Re: Chart Query

Tue, 20 May 2014 06:21:09 GMT

Thanks its working fine

Re: Re: Chart Query

jagan — Tue, 20 May 2014 06:23:31 GMT

HI,

In Variable declaration give = and in expression you can directly use

if(RowNo()<= vtop,RangeSum(Above(Sum(Sales), 1, RowNo())),0)

Refer attachment in previous thread.

Hope this helps you.

Regards,

Jagan.

Re: Chart Query

rwunderlich — Sun, 25 May 2014 19:34:00 GMT

I think it's preferable to use dimensionality() to test for the total row.

if(Dimensionality()>0,RangeSum(Above(Sum(Sales), 1, RowNo())),0)

-Rob