Question about pie chart and Dimensions

[#1]

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

[Gysbert_Wassenaar]

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

[#3]

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

[Gysbert_Wassenaar]

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

[#5]

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