topic Re: Dynamic data display as per prompt selection in QlikView

Dynamic data display as per prompt selection

Tue, 20 Sep 2011 08:35:53 GMT

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.

Re: Dynamic data display as per prompt selection

lironbaram — Tue, 20 Sep 2011 12:36:39 GMT

hei

attach is an example

hope its helps you

Re: Dynamic data display as per prompt selection

Wed, 21 Sep 2011 07:27:51 GMT

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 <

Re: Dynamic data display as per prompt selection

lironbaram — Wed, 21 Sep 2011 09:18:42 GMT

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