Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

including another expression in a combo chart

Hello experts,

I am currently trying to add to a combo chart a certain expression to display but I dont think I am going at it the correct way.

Attached below are pictures to visualize what I want to achieve and the current qlikview doc I have.

I am trying to get the revenue growth % for the selected dates to display on the analysis chart above every fiscal year.

The formula for the expression is already stated in the text box in qlikview, under (revenue growth % for the selected dates).


Kind regards,

Royce Tang

5 Replies
vinieme12
Champion II
Champion II

haven't checked the app but if you want the placement of those values to be on top , then create a dual expression

example;


=Dual(Num(YourActualExpression,'##.0%') , 0.95%)


Now the values will plot in a straight line of 95%

adamdavi3s
Master
Master

This is possible but might need some fiddling.

Create a new expression with your formula in, and set it to values on data points only, then I believe you can pad it out with carriage returns to try and align it to the top of the chart.

I'll do some digging as I am sure I saw a thread on this somewhere

Capture.PNG

Not applicable
Author

Cheers for that ! may I please ask what carriage returns are btw? I also find that my expression may be wrong as I am required to select 2 dates for it. is it possible to get the dates showing with only 1 or totally no dates being selected ?

adamdavi3s
Master
Master

I might be wrong about this, sorry I thought this would work but it doesn't look like it does (works for the pop up text though)

Just trying some other ideas for you

carriage returns are just a character to add in a new row chr(13)

adamdavi3s
Master
Master

I can't come up with a way of doing this I am afraid