topic Re: When string declared static string in stored procedure, loses formatting in Qlik in QlikView

When string declared static string in stored procedure, loses formatting in Qlik

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I currently load from a stored procedure. Recently, the strings in a particular field were declared as static strings in the database. I use these strings to format numbers in Qlik (e.g., if (Category = 'Bananas'), Num(Sum(Value), '#,##0').)

Now, the values don't populate in my table so if (Category = 'Bananas'), Num(Sum(Value), '#,##0') = null because the if condition is ostensibly not satisfied.

The field still comes in accurately and is associated with the correct values. It seems like the field values are not read in correctly just when an if statement.

Has anyone run into this issue before and found a workaround? I've tried wrapping the field in Text() and re mapping the values with no luck.

Thank you in advance!

Re: When string declared static string in stored procedure, loses formatting in Qlik

Anonymous — Tue, 04 Apr 2017 14:58:45 GMT

Can you share some screenshots of the data and issue?

Re: When string declared static string in stored procedure, loses formatting in Qlik

Anonymous — Tue, 04 Apr 2017 15:13:53 GMT

Unfortunately, the data is confidential so I can't.

The strings appear exactly how a normal string would appear in Qlik and they respond to list box selections as normal. The only problem that I'm seeing is when used in an if statement, Qlik doesn't read in the condition.

Thank you.

Re: When string declared static string in stored procedure, loses formatting in Qlik

Anonymous — Wed, 05 Apr 2017 04:09:11 GMT

Am not sure if wats happening with the if statement. How about trying if (Match(Category),'Bananas'), Num(Sum(Value), '#,##0').)??

Re: When string declared static string in stored procedure, loses formatting in Qlik

rahulpawarb — Wed, 05 Apr 2017 05:00:32 GMT

Hello Danelle,

Trust that you are doing well!

The desired if statement is:

if (Trim(Category) = 'Bananas', Num(Sum(Value), '#,##0'))

Pleas correct me If I misunderstood.

Hope this will be helpful.

Regards!

Rahul

Re: When string declared static string in stored procedure, loses formatting in Qlik

Anil_Babu_Samineni — Wed, 05 Apr 2017 05:20:14 GMT

Now, the values don't populate in my table so if (Category = 'Bananas'), Num(Sum(Value), '#,##0') = null because the if condition is ostensibly not satisfied.

Condition is not accuracy, May be like this?

If(Category = 'Bananas', Num(Sum(Value), '#,##0')) // Here, What are you trying with null. would you describe more this part

Re: When string declared static string in stored procedure, loses formatting in Qlik

Anonymous — Wed, 05 Apr 2017 14:39:46 GMT

Great idea! But, unfortunately, it didn't work.

Ultimately, we ended up creating a second field that was dual coded and I used the numeric value in the if statement to format the numbers.

Thank you for your help!