topic Re: Challenge: Two-column chart in QlikView

Challenge: Two-column chart

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

Hi, I need to create a graph with the next table:

QV can do it?

Thank you!

Carlos

Re: Challenge: Two-column chart

devarasu07 — Wed, 29 Mar 2017 18:48:02 GMT

Hi,

Something like this?

Re: Challenge: Two-column chart

el_aprendiz111 — Wed, 29 Mar 2017 20:52:46 GMT

Hi,

Re: Challenge: Two-column chart

MarcoWedel — Wed, 29 Mar 2017 21:20:19 GMT

Hi,

maybe another solution might be:

CrossTable (Type, Value)

LOAD * INLINE [

póliza, a, b

1, 7%, 12%

2, 12%, 23%

3, 9%, 9%

4, 4%, 23%

5, 2%, 24%

6, 2%, 24%

7, 18%, 8%

8, 19%, 17%

9, 7%, 3%

10, 23%, 14%

11, 7%, 13%

];

hope this helps

regards

Marco

Re: Challenge: Two-column chart

devarasu07 — Thu, 30 Mar 2017 02:37:00 GMT

Hi,

Is your issue resolved? help to close this thread. Thanks

Regards,

Deva

Re: Challenge: Two-column chart

cattaneoc — Thu, 30 Mar 2017 14:01:32 GMT

All answers are correct and applicable !! many thanks!!

Re: Challenge: Two-column chart

cattaneoc — Mon, 03 Apr 2017 13:40:49 GMT

Hi Marco,

Is it possible to modify the expression so that the zero is a separate bar?

=Aggr(Dual(Num(Floor(Poliza%,Var_Rango%),'0%')&' y '&Num(Floor(Poliza%,Var_Rango%)+Var_Rango%,'0%'),Floor(Poliza%,Var_Rango%)),Poliza%)

Var_Rango% = 5.0%

Example:

-15% y -10%

-10% y -5%

-5% y < 0%

>0% y 5%

5% y 10%

10% y 15%

thank you very much!