topic Re: Setting Currency showing no values in QlikView

Setting Currency showing no values

priyarane — Thu, 15 Oct 2015 11:36:12 GMT

Hi Community,

As attached, when I make selection Currency - USD then no value for some columns and If I clear then values are populating.

Note;

1. Only one Currency available - USD

2. Checked Data Model - its correct.

What is the error cause?

Re: Setting Currency showing no values

Thu, 15 Oct 2015 11:46:32 GMT

Hi,

Try build one pivot table where dimension will be the Currency and use the same expressions of picture. Look if exists values for others currency or just is showing '-'.

Godd Lucky!

Re: Setting Currency showing no values

priyarane — Thu, 15 Oct 2015 12:04:53 GMT

Hi Marcus,

As suggested I did it- now I got '-'. But I have to handle it in front end only like this '-' should change it to USD and If I select USD then all the values should appear. Can you please suggest

Re: Setting Currency showing no values

Thu, 15 Oct 2015 12:05:05 GMT

After tell me what happened...

Re: Setting Currency showing no values

priyarane — Thu, 15 Oct 2015 12:13:40 GMT

My need as of now - If I select Currency - USD then all values should appear all inclue Null/'-' - is there any way like that

Re: Setting Currency showing no values

Thu, 15 Oct 2015 12:14:49 GMT

You need to correct into script, this is the better way...When you load the table with the values, apply one "if", case currency is null, so replace for USD..If you want to send this part of script for I help you...

Re: Setting Currency showing no values

ionut_toader — Thu, 15 Oct 2015 12:19:21 GMT

Hi Pryia,

As I understand, there is a problem with your data sources. Use Marcos suggestion, add data source name (table name) to the pivot and this will probably show you that you don't have "Currency" field completed for all the data sources you are loading into the app.

Since you know all values are USD, I suggest you change your script in order to load "USD" in Currency field for those data sources that are missing the "USD" value. If the field "Currency" is not present in those data sources, add it in scripting.

Kind regards,

Ionut