topic Re: Funnel Chart Expression Problem in QlikView

Funnel Chart Expression Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

PFA.

I have one excel which is 2014 Data. Now, i want to split three parts.

1) Whoever more than 70

2) In between of 50 & 70

3) Below 50

Can you please help me This...

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 11:06:48 GMT

Use Calculated Dimension as below

=Aggr(If($(vAverage) < 50, '<50',

If($(vAverage) > 70, '>70',

'50-70')),name)

Expression

COUNT(Distinct name)

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 11:08:15 GMT

Use your same funnel chart

Go to Expression tab

Click on + sign of expression

Background color

Use below as background color expression

=If($(vAverage) < 50, RED(),

If($(vAverage) > 70, Green(),

RGB(100,100,100)))

Re: Funnel Chart Expression Problem

nilapril2010 — Mon, 04 Jul 2016 11:08:48 GMT

Hi,

Use the following expression in color tab

if(Your Expression>=70, rgb(100,100,100),if(Your Expression>=50 And Your Expression<70, rgb(50,50,50),rgb(25,25,25)))

Regards

Nilanjan

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 11:59:27 GMT

Manish,

Yes, Here i want to show the data

1) <20

2) >=20 and <40

3) >=40 and <60

4) >=60

PFA of excel, Please find my data of 2014 & 2015.

Updated : PFA of qvw - In that, Funnel sheet

Re: Funnel Chart Expression Problem

susovan — Mon, 04 Jul 2016 12:01:53 GMT

Hi Anil,

Your Expression has return the same value that's why all colours are same,

I have used this below expression for conditional color.

Expression: =if(vAverage>70,Red(),if(vAverage>50 and vAverage<70,Yellow(),Green()))

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 12:08:25 GMT

Susovan,

Yes, That's why i posted raw data as well. can you please have a look which i provide the above one.

- Anil

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 12:09:25 GMT

What output you are expecting?

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 12:12:42 GMT

I am expecting four colors from Funnel chart, It seems the your first reply. But, i want to show those four colors which i mention in the above limits

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 12:17:25 GMT

=If($(vAverage) < 20, RED(),

IF($(vAverage) >= 20 and $(vAverage) < 40, RGB(100,100,100),

IF($(vAverage) >= 40 and $(vAverage) < 60, RGB(10,60,200),

If($(vAverage) >= 60, Green()))))

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 12:18:48 GMT

Where i need to copy this. In the expression / Dim

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 12:20:02 GMT

Expression Background Color...

But you need to change according to your dimension names..
The answer I have given is based on your first attachment. For your 2nd qvw, you need some changes according to your fieldnames.

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 12:21:27 GMT

Manish,

Thanks for your quick response, can you please work on welcome.qvw which i share the recent. Meantime, Please have a look of raw data. And then share me that qvw, Please?

Thanks

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 12:27:01 GMT

attached

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 12:29:17 GMT

I want to show Calculated Dimension like, Your first expression reply

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 13:46:00 GMT

Manish,

Sorry for troubling. Just now i got the mail from Client.

They want to use as Dimension is - rep

Can you please help me now?

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Mon, 04 Jul 2016 13:59:39 GMT

Manish,

Last question, Is there any chance to put the Y-Axis from 0 to 100

- Anil

Re: Funnel Chart Expression Problem

MK_QSL — Mon, 04 Jul 2016 14:02:41 GMT

No axis settings in funnel chart..

Re: Funnel Chart Expression Problem

Anil_Babu_Samineni — Tue, 05 Jul 2016 10:55:19 GMT

Ok Manish,

Thanks.

Here, i want to show score into %.

How do we achieve this?