Aggregated dimension and measure - bar chart

[#1]

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 product	mapped product	flag
10000281	10094520	1
10000281	10094521	1
10000281	10094522	0
10000281	10099709	0
10000281	10099710	0
10000281	15000100	0
10000281	15074322	0
10000281	15106301	0
10000281	15106302	0
10000281	15106303	0
10000281	15106304	0
10000281	15106305	1
10000281	15106306	1
10000281	15106307	1
10000281	15106308	1
10000281	15106309	1
10000281	15106310	1
10090507	10090508	1
10000281	100193598	1
10090507	946115471	1
10090507	946122366	1
10090507	946170674	1
10090507	946175751	1
10090507	946189647	1
10000281	202631588	1
10090507	100567250	1
10090507	202630246	1
10090507	202630247	1
10090507	202630248	1
10090507	202960489	0
10090507	203198905	0
10090507	203198907	0
10090507	203198909	0
10090507	203198911	0
10090508	204731710	0
10090508	204754133	0
10090508	204754146	0
10090508	206668316	0
10090508	206668317	0
10090508	206668329	0
10090508	206668331	1
10090508	300230997	1
10090508	300510309	1
10090508	300510310	1
10090508	300510311	0
10090508	300510312	0
10090508	300510313	0
10090508	300510360	0
10090508	300568014	0

[Anonymous]

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!

[#3]

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]

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])

[#6]

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])