topic Re: If Challenge in QlikView

If Challenge

pnn44794 — Fri, 15 Dec 2017 21:59:54 GMT

Hello:

I'm having a challenge where I've built a user customizable table (credits to Richard Pearce) and some of the fields that can be included are dollar amounts. The problem is that these dollar amounts are not formatted as such. I can't format them in the load script as the fieldname is a literal, so if I try to use Num for example, Num becomes part of the fieldname. So, I'm thinking that I need some type of If statement wrapped around the following calculated dimension, but I don't know how to do so:

=$(=FirstSortedValue(DI_Dim_FieldName,DI_DIM_SortOrder,1))

I have 10 of these calculated dimensions where each one would need to account for, minimally, two different dollar amount fields (Estimated Save and FB_MYP_Annualized_Benefit) or leave the field as is. Does that make sense? The reason I have to account for them in all 10 calculated dimensions is because the end user can choose the sort order of the columns.

As always, thanks in advance fro any and all help.

Re: If Challenge

Anonymous — Fri, 15 Dec 2017 22:53:24 GMT

can you post your app?

Re: If Challenge

pnn44794 — Sat, 16 Dec 2017 00:20:39 GMT

Hello Wallo:

Give me a few and I'll post something that you can work with. Please note that I need to remove some data, but not anything that would prevent a solution. When I post it, I'll provide more info to hopefully help. Thank you in advance.

Re: If Challenge

pnn44794 — Sat, 16 Dec 2017 01:44:57 GMT

Sorry for the delay. I've attached the qvw file and sample data.

Again, I'm interested in formatting dimensions Estimated Save and MYP Annualized Benefit (and FB_Annualized Benefit) if they are one of the chosen fields.

Re: If Challenge

sunny_talwar — Sat, 16 Dec 2017 13:02:04 GMT

May be try to change the format settings for the specific field from Document properties tab

Re: If Challenge

pnn44794 — Sat, 16 Dec 2017 20:27:44 GMT

Hello Sunny:

As always, thanks for the reply. That worked. I didn't know you could do that, so I've learned something new and thanks for that. Also, again as always, thank you for your help!!! It's very much appreciated.