Qlikview expression not working for text object

[Anonymous]

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.

[vishsaggi]

Try this in your variable?

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

[maxgro · Accepted solution]

maybe

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

[Anonymous]

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

[vishsaggi]

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

[Anonymous]

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

[vishsaggi]

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.

[satishsure]

Clear Explanation about Aggr Function.Aggr Function