topic Re: Qlikview expression not working for text object in QlikView

Qlikview expression not working for text object

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

Guys,

I have an expression as in the screenshot below,

Expression - Count(DestinationUniqKey)

The count shown in bar chart is correct (168), but wrong in the case of text object (466). I couldn't find why it is showing different value in text object. Please help me to check this friends...

I've also attached the sample data and QVW file below. Thanks in advance.

Re: Qlikview expression not working for text object

vishsaggi — Fri, 07 Apr 2017 19:30:20 GMT

Try this in your variable?

= Aggr(Count( {< Customer = {'Cargosmart'} >} DestinationUniqKey), Customer)

Re: Qlikview expression not working for text object

maxgro — Fri, 07 Apr 2017 19:36:39 GMT

maybe

sum(aggr(count(DestinationUniqKey), Customer))

Re: Qlikview expression not working for text object

Anonymous — Fri, 07 Apr 2017 19:38:58 GMT

But this will work only for a particular value. Please say how to do it dynamically.

Re: Qlikview expression not working for text object

vishsaggi — Fri, 07 Apr 2017 19:50:58 GMT

I would change the Variable expression to Massimo's expression, just take off that set analysis customer and do a =

= Sum(Aggr(Count(DestinationUniqKey), Customer))

Re: Qlikview expression not working for text object

Anonymous — Fri, 07 Apr 2017 19:56:41 GMT

Thanks guys, it's working fine... May I know the reason why it was wrong?

Re: Qlikview expression not working for text object

vishsaggi — Fri, 07 Apr 2017 20:26:42 GMT

Cos your bar graph is aggregated based on Dimension Customer with count expr. you have to have the same logic if you want to display in plain textbox. So we aggregated the Count() using Dim in Aggr() function and Sum() it up based on your Selections in Customer.

Re: Qlikview expression not working for text object

satishsure — Fri, 07 Apr 2017 20:33:09 GMT

Clear Explanation about Aggr Function.Aggr Function