topic Re: Simple Script Problem in QlikView

Simple Script Problem

AH — Mon, 05 Jan 2015 07:33:25 GMT

Hi,

I have different Currency Code in my dashboard. In one tab I showed all the currency code and in another tab i showed only two currency code across the tab using filter in the script like this : if(DataAreaID ='TT','USD','GBP') as FunctionalCurrency.

Now i was trying to show only USD as the reporting currency in another tab. What should i do in the script? I used action to select only USD for that tab and its working but when i switch to other tab the USD currency selection persists which i dont want. I would like to do that from the script.

Any suggestions?

Thanks,

Shan

Re: Simple Script Problem

Anonymous — Mon, 05 Jan 2015 07:47:39 GMT

Use trigger to reset the reported currency on leaving the sheet

Re: Simple Script Problem

djsampat — Mon, 05 Jan 2015 08:29:47 GMT

View image and do the following:-

Open Sheet Properties, Select Triggers tab, On ActivateSheet, click Add Actions, Click Add, select the Action "Clear Field" (or "Clear All" if required) and in the Field, select the Field, click Ok twice and go back to the Main tab, make a few selections and then click the new Sheet1 and it will clear the selection.

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

Re: Simple Script Problem

Anonymous — Mon, 05 Jan 2015 09:09:14 GMT

Hi,

In the script define

if(DataAreaID ='TT','USD') as FunctionalCurrencyUSD,

if(DataAreaID <>'TT','GBP') as FunctionalCurrencyGBP

now you can use separate columns for you calculation or selection.

Re: Simple Script Problem

AH — Mon, 05 Jan 2015 09:23:15 GMT

Hi Chandal,

Thanks for your reply. But this script is not working :if(DataAreaID ='TT','USD') as FunctionalCurrencyUSD.

This script is working: if(DataAreaID ='TT','USD','GBP') as FunctionalCurrency.

But the second one : if(DataAreaID ='TT','USD') as FunctionalCurrencyUSD. is not working. Dont know why.

Thanks,

Shan

Re: Simple Script Problem

Anonymous — Mon, 05 Jan 2015 09:37:25 GMT

use this :

if(DataAreaID ='TT','USD',' ' ) as FunctionalCurrencyUSD,

Re: Simple Script Problem

alkesh_sharma — Mon, 05 Jan 2015 09:41:58 GMT

Use Clear All trigger on moving to other tabs and selection of USD currency, trigger, on moving to that particular tab

Probably the simplest way to address your issue.

Re: Simple Script Problem

AH — Mon, 05 Jan 2015 09:48:47 GMT

Hi Chandel,

I used this and its working

if(CurrencyCode ='USD',CurrencyCode) as ReportingCurrency,

Thanks for your feedback.

Thanks,

Shan

Re: Simple Script Problem

AH — Mon, 05 Jan 2015 09:57:46 GMT

I also tried this solution. It worked.

Thanks a lot.

Shan

Re: Simple Script Problem

djsampat — Tue, 06 Jan 2015 00:31:51 GMT

Please mark correct Answer, so the Question status can be closed.

Thanks. Glad to have been of assistance.