topic Make total as conditional expression in QlikView

Make total as conditional expression

Tue, 18 Jan 2011 10:13:14 GMT

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?

Make total as conditional expression

lironbaram — Tue, 18 Jan 2011 10:55:16 GMT

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

Make total as conditional expression

Tue, 18 Jan 2011 11:48:48 GMT

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

Make total as conditional expression

lironbaram — Tue, 18 Jan 2011 13:00:32 GMT

hei

attach is an example with improved expression

give it a try

Make total as conditional expression

amars — Tue, 18 Jan 2011 13:17:21 GMT

hei ,

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

Make total as conditional expression

Tue, 18 Jan 2011 13:27:43 GMT

This is what I need. Thank you