topic Re: Data format in single cell in QlikView

Data format in single cell

Fri, 27 Jan 2012 10:43:38 GMT

Hi there,

I have another question.

It it possible to change the data format of a single cell? I know that you can change the colour and borders via Design Grid but can I also change the number format for one cell?

E.g. I have a table where there are numbers in ###,#% and in #.### format but right now I can only choose #.### OR ###,#% but I would like to have both.

Hope you got what I'm looking for.

Thanks a lot!

Data format in single cell

oxtontom — Fri, 27 Jan 2012 11:00:16 GMT

Hi cdettmer,

I am fairly sure you can write the formatting in the expression / definition and then use an IF statement to toggle between the formatting. Though I am fairly new myself and not exactly sure of the code! my gues would be something like this

=If( Number() - Number1 < Number3

, format ####

, If( Today() - number 3 < number 2

, format ######%

, format ######,#

)

Hope this helps!

Tom

Re: Data format in single cell

Fri, 27 Jan 2012 11:44:22 GMT

Hi oxtontom,

with the expression "number" are you adressing a specific cell or do you want me to enter the number?

Thanks!!

Re: Data format in single cell

Fri, 27 Jan 2012 12:58:38 GMT

Well that is settled but QV doen't accept the term format. Does anyone knows the syntax?

Thanks!

Re: Data format in single cell

Fri, 27 Jan 2012 13:59:48 GMT

Ok I figured it out, that is the formula i'm using

=IF("expression">1,Num("expression",'#.###,#'),

("expression"<1,Num("expression",'###,#%'))