Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

I'm getting wrong data for some accounts

The total should be 21.

1 Solution

Accepted Solutions
Highlighted
Not applicable

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
Highlighted
Specialist II
Specialist II

I would use count(distinct SHORT_MBO_NAME) instead.

Hope this helps!

Highlighted
Not applicable

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.

Highlighted
Not applicable

create a compound key?

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

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

Highlighted
Not applicable

Thanks David. But it didn't work!!

Highlighted
Not applicable

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

Highlighted
Not applicable


Thanks David. It worked.

Highlighted
Not applicable

Great! Please mark Question as answered

Highlighted
Not applicable

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

Highlighted
Not applicable

Done. Thanks David.