Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression/Dimension Help

Hi guys

If I was to put the Supplier Name and Spend columns from the attached into a straight table, how would I show AFC Ajax on one row, and all the others added together on another?


Thanks in advance,

Gareth

1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi Gareth,

Use a calculated dimension:

=Aggr(If([Supplier Name] = 'AFC Ajax',[Supplier Name],'Other'),[Supplier Name])

to get:

Supplier Name Sum ([Spend (£)])
£3602388.42
Other£3524562.42
AFC Ajax£77826.00

Cheers

Andrew

View solution in original post

3 Replies
effinty2112
Master
Master

Hi Gareth,

Use a calculated dimension:

=Aggr(If([Supplier Name] = 'AFC Ajax',[Supplier Name],'Other'),[Supplier Name])

to get:

Supplier Name Sum ([Spend (£)])
£3602388.42
Other£3524562.42
AFC Ajax£77826.00

Cheers

Andrew

Anonymous
Not applicable
Author

Hi Andrew,


That's brilliant - thanks very much.

Cheers

Gareth

effinty2112
Master
Master

Hi Gareth,

You're very welcome!

Cheers

Andrew