Dynamic data display as per prompt selection

[#1]

Hi,

I have a list report displaying BookGroupID and TotalSale.

I have a currency prompt on report and as per currency selection, TotalSale will get displayed either in dollars or euros.

I want one more prompt it should contain choices such as 'EURO', 'kEURO', 'mEURO', 'Dollar', 'kDollar', 'mDollar' and the options belonging to euro should only get displayed when euro is selected from currency prompt and same is case with dolllar.

When I select EUR then normal 'TotalSale' figures should be displayed, if I select 'kEuro' then 'TotalSales figures divided by 1000 should get displayed and when 'mEuro' selected then 'TotalSale' figures in million euros should be displayed.

Same thing should be with 'dollar', 'kDollar' and 'mDollar'.

Please help me how can I achieve this?

Thanks in advance.

[lironbaram]

hei

attach is an example

hope its helps you

[#3]

Hi Iiron,

I have personnal edition of qlikview, so I can't open your file

Could you please past script here?

On Tue, Sep 20, 2011 at 6:07 PM, liron baram <

[lironbaram]

hei the script goes like this:

LOAD

country,
SalesDolar,
EuorRate,
SalesDolar*EuorRate AS SalesEuro
FROM

(ooxml, embedded labels, table is 1);

LOAD * INLINE [
CurrencyCode, AmountView, divider
1, $, 1
1, K$, 1000
1, M$, 1000000
2, €, 1
2, K€, 1000
2, M€, 1000000
];


LOAD * INLINE [
Currency, CurrencyCode
Dollar, 1
Euro, 2];

then the expression in the table is like this

sum

a nd iwve put to list boxes: on with the field curreny which has the allways one selected value checked and one with Amountview

(if(Currency='Euro',SalesEuro, SalesDolar))/min(divider)

attach is the excel file