Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show count of values in pie chart with legend?


Hi,

I have below data in excel file.

                                                                                                                                                         

IDXXAppleXXFruitXXSavouriXXCrispsXXMelon
5635602002
46474502002
6536500002
5646764502000
775676346402002
746634602002
6764765700002
574645620000
57463453400022
7435645620000
5447644500000
456565462000

0

I need to show the count of ID percentages where column values are 2 in pie chart with legend at the side as

XXApple

XXFruit

XXSavouri

XXCrisps

XXMelon.

Please can anyone suggest me.

Thanks.

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

The crosstable is still valid in access there just isn't a wizard for it :

Below will generate a qlikview table with 3 fields:

First field is 'Salesman ID' -> values are IDs straight from field with same name in access DB

2nd field is 'Fields' -> values are 'Salesman' and 'Distributor ID'... the remaining field names in the query

3rd field is 'Values' -> contains the row values from the Salesman and distributor id fields in the DB.

ODBC CONNECT TO [Salesman;DBQ=C:\Qlik Resources\Demos\10 Minute Demo\Data\Salesman.mdb];

CrossTable(Fields,Values)

LOAD `Salesman ID`,

    Salesman,

    `Distributor ID`;

SQL SELECT `Salesman ID`,

    Salesman,

    `Distributor ID`

FROM SALESMAN;

View solution in original post

6 Replies
Not applicable
Author

output should be as shown in attached. Please suggest

JonnyPoole
Employee
Employee

Here is a sample but i'm not sure if its what you asked for. Please comment on what you might need differnt

Capture.PNG

Not applicable
Author

Thanks. This matches if the data is in excel. what if the source data is coming from ms access table. how to use cross table on access table data. sorry the one which I mentioned is sample data.  please suggest

EDIT : the format is same which I have in access table.

saurabh5
Creator II
Creator II

Hi Amelia,

first load your excel table which is crosstable into straight table then use set analysis.

Table:

CrossTable(type, Data)
LOAD ID,
XXApple,
XXFruit,
XXSavouri,
XXCrisps,
XXMelon
FROM
[..\Solve.xlsx]
(
ooxml, embedded labels, table is Sheet1);

then use the expression: 

=

count(distinct {<Data={'2'}>}ID)

dimesion: type   ...............in your pie chart,nad check mark relatve in expression tab while creating your pie chart.

Regards

Saurabh

JonnyPoole
Employee
Employee

The crosstable is still valid in access there just isn't a wizard for it :

Below will generate a qlikview table with 3 fields:

First field is 'Salesman ID' -> values are IDs straight from field with same name in access DB

2nd field is 'Fields' -> values are 'Salesman' and 'Distributor ID'... the remaining field names in the query

3rd field is 'Values' -> contains the row values from the Salesman and distributor id fields in the DB.

ODBC CONNECT TO [Salesman;DBQ=C:\Qlik Resources\Demos\10 Minute Demo\Data\Salesman.mdb];

CrossTable(Fields,Values)

LOAD `Salesman ID`,

    Salesman,

    `Distributor ID`;

SQL SELECT `Salesman ID`,

    Salesman,

    `Distributor ID`

FROM SALESMAN;

View solution in original post

Not applicable
Author

Thanks. I did give a try the same and it worked. Thanks for giving me the solution.