topic Aggregated dimension and measure - bar chart in App Development

Aggregated dimension and measure - bar chart

Tue, 09 May 2017 06:21:44 GMT

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

Re: Aggregated dimension and measure - bar chart

Anonymous — Wed, 10 May 2017 17:56:42 GMT

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!

Re: Aggregated dimension and measure - bar chart

Thu, 11 May 2017 07:09:56 GMT

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

Re: Aggregated dimension and measure - bar chart

daveamz — Thu, 11 May 2017 07:21:16 GMT

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

sunny_talwar — Thu, 11 May 2017 08:39:13 GMT

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

Count(DISTINCT [my product])

Re: Aggregated dimension and measure - bar chart

Thu, 11 May 2017 08:57:57 GMT

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

sunny_talwar — Thu, 11 May 2017 09:41:20 GMT

Here you go....

Dimension

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

Expression

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

Mine = Count(DISTINCT [my product])