topic Re: Different cell formats for the same column? in QlikView

Different cell formats for the same column?

Wed, 23 Sep 2015 05:05:29 GMT

Hi !

I have data and I want a different format for each value depending it is an index, price, % or unit value.

Is it possible? I tried to used Text Format in the Expression Tab, it does not work!

The following table is an example of the expected output:

	Jan	Feb	Mar
Index	0.064	0.455	0.125
Price	200.00	1,506.58	20,234.58
%	1.5%	2.3%	1.4%
Units	1,234	495	38,423

Thanks a lot for all your suggestions!

Cordially,

--- maoh

Re: Different cell formats for the same column?

Wed, 23 Sep 2015 05:08:19 GMT

Hi,

You can achieve it by using the custom format cell.

Re: Different cell formats for the same column?

Wed, 23 Sep 2015 05:15:16 GMT

First click on the grid and then right click on the chart and select the custom format cell as shown in figure 1

and do the changes as per your requirements as shown in the figure 2

Re: Different cell formats for the same column?

sunny_talwar — Wed, 23 Sep 2015 05:23:14 GMT

Yes it is possible in a straight table or pivot table by using if statement:

If(FieldName = 'Index', Num(Expression, 'Formatting1), If(FieldName = 'Price', Num(Expression, 'Formatting2'),... and so on.

HTH

Best,

Sunny

Re: Different cell formats for the same column?

jonathandienst — Wed, 23 Sep 2015 05:56:25 GMT

If you create the table with Index, Price etc as expressions and the month as a dimension, and select the Horizontal option in Presentation, the field formats in Number become row formats.

Re: Different cell formats for the same column?

Wed, 23 Sep 2015 18:19:29 GMT

It works!

Also, I must indicate 'Expression Default' as number format settings (Tab Number). If you indcate another number format settings, it does not work.

Then, the result looks like:

Thanks a lot for all your suggestions

Re: Different cell formats for the same column?

Wed, 23 Sep 2015 18:19:57 GMT

Thanks a lot for your suggestion.