topic Re: text format in QlikView

text format

Tue, 03 Apr 2012 09:52:32 GMT

hi i have a column in a pivot table which have values with $ sign notation and i want 1 column to be shown without $ sign. how can i do that?

text format

vijay_iitkgp — Tue, 03 Apr 2012 10:04:29 GMT

If it is dimension then you can use purgechar(field,'$') as calculated dimension

text format

jagan — Tue, 03 Apr 2012 10:07:48 GMT

Hi,

Use calculated dimension

Dimension 1 - without $ symbol

= Replace(FieldName, '$', '')

Dimension - with $symbol

=FieldName

text format

Wed, 04 Apr 2012 04:57:31 GMT

no its not a dimension. its an output of an expression that i have used in the pivot table and its not a string..its a no.

its coming like this $89750.90 and i want to remove it only from the ist row.

text format

Wed, 04 Apr 2012 05:01:09 GMT

hi Jagan

its not a dimension and the solution you have provided is not even wrking for a dimension.

text format

vijay_iitkgp — Wed, 04 Apr 2012 06:15:31 GMT

Please go to Chart Properties----->Number------>

you can see the formatting option. here you can remove $.

Regards

Vijay

text format

Wed, 04 Apr 2012 06:24:20 GMT

hi Vijay

i dont want to remove it from the whole column i just want to do it for the ist row of column.

i have rows like a,b,c,d and their corresponding columns are p1,p2,p3.

i want to do it for only a.

Re: text format

Anonymous — Sat, 16 Dec 2017 18:18:43 GMT

In this case you need to evaluate first row by using RowNo() function and then use the number formatting function like Num# to format your expression for true and flase condition of if function.

If(RowNo() = 1, Num#(Expression,formatforfirstrow),Num$(Expresiion,Formatforotherrows)

Hope it helps!