specifc rows formatting in Qlikview

[vireshkolagimat]

hi guys,

I have a table that has 10 rows and first row being the header column. Is there anyway to set different number formatting to different rows.

I need first rows values in integer format and rest in %.

Header 1	Header 2	Header 3
ABC	333	4567
PQR	10.00%	20.00%
LMN	6.99%	2.33%
XYZ	67.00%	12.36%

Regards,

Viresh

[vireshkolagimat]

Hi, thanks it works fine if i don't use the qualify statement. I am using qualify statement to avoid synthetic key and trying the above method but i am not getting the result. Below is the sample expression.

=If(DWE.category=[C F], num(DWE.42460, '##.0'), num( DWE.42490/100, '##.00%'))

Here DWE is the table name

category is the dimension and 42660 and 42490 are dates which are used in expression.

let me know if you need any details.

Regards,

Viresh

[sunny_talwar]

What is [C F] here? A value within DWE.category? Does it include the square brackets? If it doesn't, try this:

If(DWE.category = 'C F'

if it does, then may be this:

If(DWE.category = '[C F]'

It would be helpful if you can provide some screenshots of your expression and chart where you are using this

[vireshkolagimat]

Hey thank you. I got it.

[sunny_talwar]

Great!!

In addition to marking helpful responses, I would request you to close this thread by marking correct answer as well.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny