topic dynamically change number formats on graph in QlikView

dynamically change number formats on graph

Tue, 30 Oct 2012 15:05:35 GMT

Hi,

I'm trying to dynamiclly change the number format on a graph. Some of my lines of data are % and others are just numbers, so when the user filters I want the graph to change to what they have filterd on. I've got everything working except the number formats.

I was able to do this fine on a pivot but unfortuantly the same logic does not seem to work on the graph. Heres what I used for the pivot:

IF(NumberFormat='%',NUM(SUM( {$<Type={'MonthTarget'}>} Data),'0.00%'),IF(NumberFormat='0.00',NUM(SUM( {$<Type={'MonthTarget'}>} Data),'0.00'),SUM( {$<Type={'MonthTarget'}>} Data

)))

Any help would be greatly appreciated.

Cheers

Simon

Re: dynamically change number formats on graph

CELAMBARASAN — Tue, 30 Oct 2012 15:16:16 GMT

What kind of number format settings your using for the graph?

Check the number format settings in the chart properties--> Number tab.

This should be expression default for your case.

Re: dynamically change number formats on graph

Anonymous — Tue, 30 Oct 2012 15:26:59 GMT

can you uload a sample file ?

Re: dynamically change number formats on graph

Tue, 30 Oct 2012 15:29:35 GMT

The number format is set to Expression Default.

When I do table preview, the data is showing up as a percentage but it does not display the graph as such or my my pivot.

Cheers

Re: dynamically change number formats on graph

Tue, 30 Oct 2012 15:29:48 GMT

The number format is set to Expression Default.

When I do table preview, the data is showing up as a percentage but it does not display the graph as such or my my pivot.

Cheers

Re: dynamically change number formats on graph

CELAMBARASAN — Tue, 30 Oct 2012 15:35:14 GMT

Can you upload the file?

Re: dynamically change number formats on graph

Tue, 30 Oct 2012 15:41:22 GMT

Hi,

I've added my file.

If you change the category, the graphs change to reflect the data, but it does not change the number format.

Cheers

Re: dynamically change number formats on graph

CELAMBARASAN — Tue, 30 Oct 2012 17:05:10 GMT

Number Format is null for all the months because two different number formats exists in each month.

Re: dynamically change number formats on graph

whiteline — Tue, 30 Oct 2012 19:01:50 GMT

Hi.

In your example the problem is not with number format.

There is no values to show when '%' is selected.

Add a Table Box with all fields and you'll see there are only MeasureID=3.