topic Re: Question about pie chart and Dimensions in QlikView

Question about pie chart and Dimensions

Wed, 06 Nov 2013 11:43:06 GMT

Hi to all, I'm new with QlikView and I'm trying to create a pie chart, with the following requirements:

I have two table, a lookup table called LAVORI with 2 columns

COD_LAV int

DESCR varchar(500)

Another table called RICHIESTE with 3 columns:

ID_RICH int

COD_LAV int

DESC_RICH varchar(500)

IN SQL SERVER I do the following query

select DESCR, count(ID_RICH) FROM LAVORI L LEFT OUTER JOIN RICHIESTE R on L.COD_LAV = R.COD_LAV GROUP BY L.COD_LAV, DESC_LAV and all works fine,

In QlikView I've created a pie chart with 2 dimensions, COD_LAV and DESCR, but I'd like to display only DESCR.

So i need to group by with the following order but I only want to display the second dimension.

Can someone help me to perform this task?

Best regards and thank you for the help.

Fabrizio

Re: Question about pie chart and Dimensions

Gysbert_Wassenaar — Wed, 06 Nov 2013 12:16:39 GMT

Use only DESCR as dimension. If that doesn't help post a sample document.

Re: Question about pie chart and Dimensions

Wed, 06 Nov 2013 13:50:26 GMT

Dear Gysbert, thank you for your reply, this could be a solution......just a quick question

what happen if I have the following situation

LAVORI with two rows,

ID DESCR

1 A

2 A

Is QlikView correctly handle this situation (displaying two different slices) or group all values in the same pie chart sector?

Best regards

Fabrizio

Re: Question about pie chart and Dimensions

Gysbert_Wassenaar — Wed, 06 Nov 2013 14:10:39 GMT

I have no idea what you're trying to ask.

Re: Question about pie chart and Dimensions

Thu, 07 Nov 2013 10:43:49 GMT

Dear Gysbert, sorry. I'll try to explain better my question

If I have a situation in my lookup table with the following values

COD_LAV DESCR

1 A

2 A

and in my table RICHIESTE the following records

RICHIESTE

ID_RICH COD_LAV DESC_RICH

1 1 First

2 2 Second

Is possible to group in QlikView for COD_LAV column but display the value of DESCR column ?

I hope this can clarify the subject.

Best regards

Fabrizio