Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

If Challenge

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.

Tags (1)
1 Solution

Accepted Solutions

Re: If Challenge

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

Capture.PNG

5 Replies
Highlighted
atkinsow
Valued Contributor II

Re: If Challenge

can you post your app?

Partner
Partner

Re: If Challenge

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.

Partner
Partner

Re: If Challenge

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

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

Capture.PNG

Partner
Partner

Re: If Challenge

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.