Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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
Author

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

daveamz
Partner - Creator III
Partner - Creator III

Hi Jithu,

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

Regards,

David

sunny_talwar

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

Count(DISTINCT [my product])


Capture.PNG

Not applicable
Author

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

sunny_talwar

Here you go....

Dimension

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

Expression

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

Mine = Count(DISTINCT [my product])