Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I'm getting wrong data for some accounts

The total should be 21.

1 Solution

Accepted Solutions
Not applicable
Author

You should be able to simple group the three fields you want to count...and do a count(distinct Field1&field2&field3)

View solution in original post

11 Replies
jerem1234
Specialist II
Specialist II

I would use count(distinct SHORT_MBO_NAME) instead.

Hope this helps!

Not applicable
Author

Hi Jeremiah,

count(distinct SHORT_MBO_NAME) wouldn't help because if I do that, all the statuses will be counted as 1 each which is not true. There are 48 accounts in total and each account has 7 MBO's and I have data for 3 months. So total should come up to 48*3*7= 1008.

Not applicable
Author

create a compound key?

Count(distinct (Field1 &'|'& Field2 &'|'& Field3))

Preferred method would be to create this multi field key in the load script

Not applicable
Author

Thanks David. But it didn't work!!

Not applicable
Author

You should be able to simple group the three fields you want to count...and do a count(distinct Field1&field2&field3)

View solution in original post

Not applicable
Author


Thanks David. It worked.

Not applicable
Author

Great! Please mark Question as answered

Not applicable
Author

Good rule for the future is to name your forums with the specific question, so the next person with your problem can find the solution.

"Count the distinct of multiple fields" would be a good name - may want to change it

Not applicable
Author

Done. Thanks David.