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: 
danialier
Creator III
Creator III

edit expression in text box

I have four dimensions: revenues, countries, products and customers

By selecting an specific product in a List Box I want the Text Box to show the revenues for an specific country (Germany) and for an specific customer (AAA) for the product selected.

The formula I used in the Edit Expression is:

  = sum({<Country={'Germany'}>}{<Customer={'AAA'}>} Revenues)

However this formula does not work and it gives the revenues for Germany but for all customers (not just for AAA customer)
Can you please help ?
Thanks !
dani

1 Solution

Accepted Solutions
Not applicable

sum({<Country={'Germany'},Customer={'AAA'}>} Revenues)

View solution in original post

3 Replies
Not applicable

sum({<Country={'Germany'},Customer={'AAA'}>} Revenues)

sundarakumar
Specialist II
Specialist II

sum({<Country={'Germany'},Customer={'AAA'}>}Revenues)
If you want to make it show irrespective of user selections, you would need to use

sum(1{<Country={'Germany'},Customer={'AAA'}>}Revenues)

-Sundar

danialier
Creator III
Creator III
Author

excellent ! thanks !