topic Re: Bar chart in QlikView

Bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

I have the data as shown below,

Field	Customer	ID
A	C1	1
B	C2	2
C	C1	3
D	C2	1

Expected Output:

I want the no. of Fields which has same IDs. Both fields have same IDs but from different customers in the above bar chart.

Re: Bar chart

vinieme12 — Sat, 29 Jul 2017 09:50:39 GMT

sum(AGGR(if(Count(DISTINCT TOTAL <ID> Customer)>1,1,0),Customer,ID))

Re: Bar chart

vinieme12 — Sat, 29 Jul 2017 09:51:25 GMT

Also you have close your earlier Thread!!

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Bar chart

Anonymous — Mon, 31 Jul 2017 10:29:23 GMT

Thanks Vineeth, It's working.. but when I make a selection in Customer, there is no value in the chart. Could you please explain this expression in detail?

I couldn't understand it.

Re: Bar chart

vinieme12 — Mon, 31 Jul 2017 10:44:49 GMT

try below

sum(AGGR(if(Count({<Customer>}DISTINCT TOTAL <ID> Customer)>1,1,0),Field,Customer,ID))

To understand how its working do the below

Use ID as Dimension and below expression to count how many times the ID field is Repeated for different customer

=Count({<Customer>}DISTINCT TOTAL Customer)

So using

Count({<Customer>}DISTINCT TOTAL <ID> Customer)>1 << gives us the same view by ID field

Re: Bar chart

Anonymous — Mon, 31 Jul 2017 10:57:10 GMT

Thank you so much Vineeth. But I have one more doubt on this.

Assume instead of using this expression in charts directly (in run time), I store this expression in the script using SET or LET function in a variable.

Now could you tell me which method will take loading issues in the front end from below,

1. Writing expressions in the charts directly - first data will be fetched into the model and then the expression will be processed.

2. Store those expressions in the script using SET or LET functions - Expressions are processed and will be stored in memory.

please say which method is preferable and also please intimate whether above mentioned 2 points are correct.

Re: Bar chart

Anonymous — Mon, 31 Jul 2017 12:41:49 GMT

Also Vineeth, I need to know whether this expression can be done as a dimension by script wise rather than an expression.