Maintaining Formats

[ngrunoz]

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.

[vinieme12]

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

How to get answers to your post?

[ngrunoz]

Attached Sample Data

[bertinabel]

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.

I hope I've helped

Regards

[rwunderlich · Accepted solution]

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