topic Re: Occurrence Count of Column Data in QlikView

Occurrence Count of Column Data

shannoypaul — Tue, 22 Apr 2014 12:29:38 GMT

I have two tables Master and Detail.

I have to find the number of occurrences of data Company in IceCream data.

for e.g Occurrence of Amul is 2 and Occurrence of Kwality is 2.

Re: Occurrence Count of Column Data

its_anandrjs — Tue, 22 Apr 2014 12:37:19 GMT

Load your table like

Master:

Load * Inline

[

Company, Location

Kwality, Mumbai

Amul, Bangalore

];

Left Join

Detail:

Load * Inline

[

IceCream, Location

Sundae Kwality, Mumbai

Cone Kwality, Mumbai

Cornetto Amul, Bangalore

Family Pack Amul, Bangalore

];

Noconcatenate

Final:

LOAD

Location&'_'&Company&'_'&IceCream as Key,

IceCream,

Location,

Company

Resident Master;

DROP Table Master;

And on Straight chart take

Dimension:- Company

Expression:- Count(Location) //as Occurance as label

Re: Occurrence Count of Column Data

shannoypaul — Tue, 22 Apr 2014 12:40:38 GMT

If we remove the location column, lets suppose we have only one column in one table

Re: Occurrence Count of Column Data

alexandros17 — Tue, 22 Apr 2014 12:41:03 GMT

Here it is

Re: Occurrence Count of Column Data

its_anandrjs — Tue, 22 Apr 2014 12:45:26 GMT

Then there is no relation between the tables and if there is only one column then count its frequency of occurrence.

Re: Occurrence Count of Column Data

its_anandrjs — Tue, 22 Apr 2014 12:51:45 GMT

I think you asking about if there is only one single columns and there are 4 values and each has 2 occurrence if i am right then see the example for that.

LOAD *,RecNo( ) AS Rowid;

LOAD * Inline[

City

Mumbai

Banglore

];

In the above table i have 4 values and each has 2 occurrence then we count its rowcount as a frequency

in straight Dimension:-City and expression :- Count(Rowid)

Regards