topic Re: Maintaining Formats in QlikView

Maintaining Formats

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

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.

Re: Maintaining Formats

vinieme12 — Fri, 10 Mar 2017 09:05:32 GMT

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

How to get answers to your post?

Re: Maintaining Formats

ngrunoz — Fri, 10 Mar 2017 18:23:23 GMT

Attached Sample Data

Re: Maintaining Formats

bertinabel — Fri, 10 Mar 2017 19:15:43 GMT

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

Re: Maintaining Formats

rwunderlich — Fri, 10 Mar 2017 21:30:11 GMT

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