Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

dynamically change number formats on graph

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

8 Replies

Re: dynamically change number formats on graph

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.

srikanthsri1
Valued Contributor

Re: dynamically change number formats on graph

can you uload a sample file ?

Not applicable

Re: dynamically change number formats on graph

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

Not applicable

Re: dynamically change number formats on graph

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

Can you upload the file?

Not applicable

Re: dynamically change number formats on graph

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

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

whiteline
Honored Contributor II

Re: dynamically change number formats on graph

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.

Community Browser