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: 
Not applicable

Make total as conditional expression

Is it possible to make total conditional? For local currency i may not show the total because each country has other currency and total makes no sense, but if USD is selected total should be shown.

How can I make this?

5 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

attach is example of what i think you asked for

the examples assumes that each country is using only one currecny

hope its helps you

Not applicable
Author

The situation is different, I have sales in USD for each country and Sales in Currency of the country, if i choose to see sales in USD, the total my appear, if i choose Local Currency the total may only appear if i have chosen 1 country.

example:

Szenario 1, Sales in USD for each country, no country selection, Currency Selection: USD:

Brand,Country,Sales

A1, FRANCE, $12

A2, FRANCE, $15

A2, ENGLAND, $10

Total, $37

Szenario 2, Sales in Local Currency for each country, FRANCE selected, Currency Selection: Local Curency:

Brand,Country,Sales

A1, FRANCE, 10.50

A2, FRANCE, 18.50

Total, 29 --> This is ok because only one country is selected

So far so good, but if:

Szenario 3, Sales in Local Currency for each country, no Country selection, Currency Selection: Local Curency:

A1, FRANCE, 10.5

A2, FRANCE, 18.5

A2, ENGLAND, 5.0

-->> Total, 34 that should not appear, because a total of value with different currency is useless

lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example with improved expression

give it a try

amars
Specialist
Specialist

hei ,

check how about showing the total's in the header. Thanks

Not applicable
Author

This is what I need. Thank you