Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Aggregated dimension and measure - bar chart

I have data like this and I want to plot a bar chart where dimension will be count(mappedproducts) and measure is count(myproduct) and I want to filter the data based on flag. Is there any way to model this without aggregating outside the model. ex: I want to how many products has 10 mapped products,, how many products has 20 mapped products so on ..... how many zero mapped products are there like that.... Something like below chart

   

my productmapped productflag
10000281100945201
10000281100945211
10000281100945220
10000281100997090
10000281100997100
10000281150001000
10000281150743220
10000281151063010
10000281151063020
10000281151063030
10000281151063040
10000281151063051
10000281151063061
10000281151063071
10000281151063081
10000281151063091
10000281151063101
10090507100905081
100002811001935981
100905079461154711
100905079461223661
100905079461706741
100905079461757511
100905079461896471
100002812026315881
100905071005672501
100905072026302461
100905072026302471
100905072026302481
100905072029604890
100905072031989050
100905072031989070
100905072031989090
100905072031989110
100905082047317100
100905082047541330
100905082047541460
100905082066683160
100905082066683170
100905082066683290
100905082066683311
100905083002309971
100905083005103091
100905083005103101
100905083005103110
100905083005103120
100905083005103130
100905083005103600
100905083005680140
6 Replies
alakshmanan
New Contributor III

Re: Aggregated dimension and measure - bar chart

This is possible.

For the bar chart:

1. Choose a "Bar Chart"

2. Add "mapped product" in your dimension

3. Add "Count(my product)" in your measure

For the "flag" filter:

1. Choose a "Filter Pane"

2. Add "flag"

You should be good to go! Let me know if this doesn't work.

Happy Qlik-ing!

Not applicable

Re: Aggregated dimension and measure - bar chart

I want to Add count(mapped product) in the dimension.... What you are saying is how to use bar chart ..... Please read my question one more time

daveamz01
Contributor III

Re: Aggregated dimension and measure - bar chart

Hi Jithu,

I'm not sure if this is the expected result but have a look at the attach.

Regards,

David

Re: Aggregated dimension and measure - bar chart

Only thing I would propose to change would be to change the expression to this

Count(DISTINCT [my product])


Capture.PNG

Not applicable

Re: Aggregated dimension and measure - bar chart

Can you just send me the expression... since the file what you have sent is a qlik view file and I am using qliksense.... to I am not able to see the reports here. Thank you

Re: Aggregated dimension and measure - bar chart

Here you go....

Dimension

=Aggr(Count(DISTINCT [mapped product]), [my product])

Expression

daveamz01‌'s = Count([my product])

Mine = Count(DISTINCT [my product])

Community Browser