Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Partner Ambassador/MVP
Partner Ambassador/MVP

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 III
Champion III

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

How to get answers to your post?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
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
Partner Ambassador/MVP
Partner Ambassador/MVP

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