Can i format vlaues in one column differently?

[#1]

hi All , I have table with Netsales and % Netsales in qlikview and i want to show $ to value and % to its percentalge value.. The sample view of table looks like this,, can you pelase help me here

ColumnA                      ColumnB

Net Saels                     $ 25, 550

% change Net              % 5.7

thanks       

[MayilVahanan]

Hi

Use Num() function

Num(Sum(Netsales),'#,##0') for sales

Num(Sum(Netsales),'#,##0.#0%') for percentage

hope it helps

[#3]

If you are using ValueList, you can specify which one should be what format. See attached.

[#4]

Hi Mayil,   I am looking for different format in onwe column of table. if you look at my example above, there is only one COLUMN and two vaalues and i want different format symbol.  $ fr first row and % for second.

[#5]

Hi Rebecca, Thank you your reply.  if i expect only one column with these two values, like you have loaded inline table with two columns, i am expecting both values in ColumnB as shown above.  and input does not have Percentage, it is just it should show up on my output table.

THanks again fr your reply.

[kaushiknsolanki]

Hi,

     Have a look at the attachment.

     Hope this will help.

Regards,

Kaushik Solanki

[#7]

Hi Kaushik,,    Thnak you for your response.. so here is the situation, i do not need to calculate expression.. i havealready straight table and all i want is that place $ sign next to value and place % sign next to one cell

so for example here is source data

Fact             Measure

NetSales       20,000

Op profit        5,000

% Sales         20.7

What i want is this

Fact             Measure

NetSales       $20,000

Op profit        $5,000

% Sales         %20.7

[kaushiknsolanki · Accepted solution]

Hi,

     In this case you should use the if statement something like this.

     if(wildmatch(Fact,'*%*'),'%'&Measure,'$'&Measure)

Regards,

Kaushik Solanki