Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have 2 tables Table1 and Table2 both linked based on ID column.
In Table1 ID column has an unique value and in Table2 ID do not have unique values.
Now i have created a straight table with
Dimensions as Branch (from Table1), Reason (Table2)
Expression as Count(ID)
But the problem is above expression is giving me distinct ID
and when i changed my expression to Count(aggr(NODISTINCT Count(ID),Branch,Reason)). I am getting the correct result
or Remove branch as dimension and keep expression as count(ID) the also I am getting the correct result.
Can any one tell me the reason for this kind of behaviour?
May be look here Count or Count distinct?
Manish, did Sunny's link to the Design Blog post help? Here are a couple of others that may be related as well:
Here is the base URL to the Design Blog where you can search on your own as well:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
If Sunny's post did help, be sure to use the Accept as Solution button on his post to give him credit for the help. If the above does not work, I am not sure I can come up with anything further, but hopefully it will potentially fill in any remaining gaps.
Regards,
Brett
Sorry but I couldn't simulate the issue here:
I'm getting the full count of ID without distinct qualifier:
Is there anything I missed out?
My mock data looks like this:
Raw:
load * inline [
Branch,ID
abc,123
def,456
ghi,789
];
Raw2:
load
Reason,ID inline [
Reason,ID
aaa,123
bbb,123
ccc,456
ccc1,456
ddd,789
ddd1,789
];