Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sum by categories

Hi,

I have 2 fileds

categamount
A - categ112
A - categ2100
A - categ1123
A - categ355
B - categ3361
B - categ4488

i need to make totals

- on transactions where categ starts with "A-"

- on transactions where categ starts with "B-"

thanks in advance

1 Solution

Accepted Solutions
Greg_Williams
Employee
Employee

Possible Solution?

=left(categ,1) as a calculated dimension in the Dimension tab of a straight table or chart?

See the attachment (built with 11.20 sr5)

Hope this Helps.

Greg

View solution in original post

2 Replies
Greg_Williams
Employee
Employee

Possible Solution?

=left(categ,1) as a calculated dimension in the Dimension tab of a straight table or chart?

See the attachment (built with 11.20 sr5)

Hope this Helps.

Greg

Anonymous
Not applicable
Author

Thank you Greg!

It made the work ...