Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
wuming79
Contributor

How to do multiple counts for unique rows?

Hi,

I have a table as below:

NameFruitsAmt Spent
JohnApple1
JohnApple1
JohnOrange3
JohnBanana4
JohnOrange3
AdamApple1
MaryApple1
MaryOrange3

Adam

Pear2
MikeBanana4

I tried

dimension field = Name

dimension field = Count(distinct Fruits)

dimension field = Sum(Amt Spent)

but I keep getting errors like invalid dimension.

How do I make a table on my sheet that will count the number of fruits bought and also sum the total spent?

Example:

NameNo of Fruits boughtTotal Spent
John412
Adam11
Mary24
Mike14
1 Solution

Accepted Solutions
Luminary
Luminary

Re: How to do multiple counts for unique rows?

Try Sum([Amt Spent]). There is a space in the name, that is why you need brackets.
Also create columns 2 and 3 as measures, not as dimensions.

View solution in original post

1 Reply
Luminary
Luminary

Re: How to do multiple counts for unique rows?

Try Sum([Amt Spent]). There is a space in the name, that is why you need brackets.
Also create columns 2 and 3 as measures, not as dimensions.

View solution in original post