topic Re: Which chart suits best? in QlikView

Which chart suits best?

Fri, 03 Oct 2014 10:22:05 GMT

Hi,

Can anyone suggest me please which chart will suit if there is two dimensions and three expressions to show as a graphical representation.

Thanks.

Re: Which chart suits best?

alexandros17 — Fri, 03 Oct 2014 10:24:12 GMT

Scatter Chart or Grid Chart

Re: Which chart suits best?

Fri, 03 Oct 2014 10:28:37 GMT

Thanks. Is there any other chart would suit? because these two not looking god with data. Please suggest

Re: Which chart suits best?

Fri, 03 Oct 2014 10:29:50 GMT

What are you triying to measure ?

Could you provide an example ?

Re: Which chart suits best?

Fri, 03 Oct 2014 10:38:50 GMT

Thanks. please see below

Dim 1 = Week

Dim 2= Customer

Exp 1 =Count(If(MixMatch(Details,'outcome','outcome to','Exclude','outcome Reduce'),ID))

Exp 2 =Count(If(MixMatch(Details,'Proper','Proper to','Poland','Proper Into'),ID))

Exp 3 = Exp 1+Exp 2

Re: Which chart suits best?

Fri, 03 Oct 2014 10:56:34 GMT

If it can´t be a pivot table I would go for the trellis option in the dimensions tab so you can have a different chart (bar chart) for every week.

Re: Which chart suits best?

Colin-Albert — Fri, 03 Oct 2014 11:04:26 GMT

Another other option could be to have the 3 expressions as a cyclic group, so your chart would have 2 dimensions and one cyclic expression. Just use the Group option on the expression tab.

Re: Which chart suits best?

Fri, 03 Oct 2014 11:08:41 GMT

Thanks. when I am using Trellis it is showing too few dimensions. how can I set this?

Re: Which chart suits best?

Fri, 03 Oct 2014 11:09:51 GMT

Thanks. how to make the expressions as Cyclic. Please suggest me.

Re: Which chart suits best?

Fri, 03 Oct 2014 11:13:00 GMT

U can use Grid chard, but it required 3 dim and 1 expr, in case u can create 3rd dim with expression list and one expr. image and sample included.

isnt best solution, but original 😃

Re: Which chart suits best?

Colin-Albert — Fri, 03 Oct 2014 11:21:12 GMT

Use the Group option on the expressions tab or drag one expression over another.

You will see a yellow cycle arrow when expressions are grouped.

You can remove the group using Ungroup

Re: Which chart suits best?

Sat, 04 Oct 2014 10:08:41 GMT

Use Pivot Table, Straight Table.