topic Re: edit expression in text box in QlikView

edit expression in text box

danialier — Thu, 09 Jan 2014 15:47:25 GMT

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

Re: edit expression in text box

Thu, 09 Jan 2014 15:52:19 GMT

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

Re: edit expression in text box

sundarakumar — Thu, 09 Jan 2014 16:02:17 GMT

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

Re: edit expression in text box

danialier — Thu, 09 Jan 2014 16:02:47 GMT

excellent ! thanks !