topic Show Unique count and Common count ? in QlikView

Show Unique count and Common count ?

gauravgg — Sat, 02 Sep 2017 07:40:39 GMT

I have the following type of data

I want to show the following two question in Bar graph in qlik sense

How many parts are used accross models?

i.e As we can see in the above table, Parts:- P1,P2,P3,P4 are used in more than one model .

How many of the parts are unique ?

i.e As we can see in the above table Parts:- P5,P8 are used only in Model B and Model D respectively .

I want to show it in Bar graph

Were

Dimension = Model

Expession1 for count of parts in that model

Expression2 of count of unique parts in that model

Can anyone help me in this

thanks in advance

Anil_Babu_Samineni — Sat, 02 Sep 2017 08:39:36 GMT

May be like?

Dimension - Model

Expressions are

i) Count(parts)

ii) Count(DISTINCT parts)

Kushal_Chawda — Sat, 02 Sep 2017 10:07:39 GMT

what is expected output in numbers?

effinty2112 — Sat, 02 Sep 2017 10:53:35 GMT

Hi Gaurav,

Parts used in more than one model:

=concat(Aggr(if(Count(DISTINCT Model) >1,Parts),Parts),',')

returns

P1,P2,P3,P4

Parts used in only one model

=concat(Aggr(if(Count(DISTINCT Model) =1,Parts),Parts),',')

P5,P8

Your bar chart

The blue bar shows number of parts, the red the number of parts used only in that model.

Cheers

Andrew

gauravgg — Mon, 04 Sep 2017 15:05:39 GMT

Thanks andrew for relpy

I also want the count of parts which are present in all the models ?

Can u help me in this

Thanks in advance