Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
CELAMBARASAN
Partner - Champion
Partner - Champion

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.

Anonymous
Not applicable
Author

can you uload a sample file ?

Not applicable
Author

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
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Can you upload the file?

Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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

whiteline
Master II
Master II

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.