Qlik Community

Ask a Question

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

relative position and values ​​between two graphs

Hi all.

I'd want to obtain this kind of graph

the chart is easy to get. The problem is the line "Change(%)".

In this section, I want the % between a quarter and the previous quarter (7,4 is 29-27=2 and 2 is 7.4% of 27). The first value is always " - ", the others are according to the results of the graph.

Again, I'd want the numbers remain aligned to the quarter (1Q13, 1Q14 ...) of the X axis of the graph.

how can I do?

Many thanks in advance.

Luca

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

A better solution...

View solution in original post

19 Replies
Clever_Anjos
Employee
Employee

Put a straight table just below of your bar graph.

Mark it as "Horizontal" and use same dimension of your graph bar

Gysbert_Wassenaar

Well, not quite what you're asking for, but pretty close I think. See attached qvw.


talk is cheap, supply exceeds demand
Clever_Anjos
Employee
Employee

PFA

Not applicable
Author

thanks, Clever.

% count is ok, but alignment is lost when data changes.How can I dynamically tune the size of the table with those of the graph?

luca

Clever_Anjos
Employee
Employee

You mean when showing less values?

Not applicable
Author

Yes, exactly.

if the values ​​are more (or less), the alignment is lost.

many thanks

luca

Clever_Anjos
Employee
Employee

I don´t see how I could do that

Not applicable
Author

is it possible get the position of the legend of the x axis (1Q13, 1Q14 ..) and on this build the table?

Clever_Anjos
Employee
Employee

I´m almost sure not, you can´t get it