Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ngrunoz
Contributor II
Contributor II

Maintaining Formats

I have a document which has got text, numbers and Dates. when I use filters(Remove(Row, RowCnd(CellValue, 2, StrCnd (null))) in the Script editor to remove some of the rows it distorts the Number and Date formats. How can I Edit it in order to maintain the same formats.

1 Solution

Accepted Solutions
rwunderlich

The filters do have the unfortunate side effect of losing the formats.  You can restore them in the script by wrapping the fields in Num() or Date() functions as appropriate.

Date([Movement Date]) as [Movement Date],

num([Value Purchased], '$#,##0.00') as [Value Purchased]

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

4 Replies
vinieme12
Champion II
Champion II

Please post a sample excel file , screenshots so people here can help you better

How to get answers to your post?

ngrunoz
Contributor II
Contributor II
Author

Attached Sample Data

bertinabel
Creator
Creator

Hi, story

    Try the following:

   

  • In the table properties, in the Number option, you choose the field and enable the "Ignore document settings" box and choose the format that you choose according to the information in your field.

Formats_1.JPG


Formats_2.JPG


I hope I've helped


Regards

rwunderlich

The filters do have the unfortunate side effect of losing the formats.  You can restore them in the script by wrapping the fields in Num() or Date() functions as appropriate.

Date([Movement Date]) as [Movement Date],

num([Value Purchased], '$#,##0.00') as [Value Purchased]

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post