Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
hobanwashburne
Creator
Creator

Unusual chart request

A senior manager has asked me if I can put together a QV application that would display the following chart for a given selected customer:

X Axis = Net Sales

Y Axis = Gross Margin

2 Data points: FY2013 & FY2014

and if possible a line connecting the two with an arrow indicating the trend direction

I am confident that I can calculate the two values, but it is unclear to me how to format in such a way that QV displays the desired result. Does anyone have an example of something similar?

Chart01.jpg

Labels (1)
1 Solution

Accepted Solutions
maxgro
MVP
MVP

in your Qlik installation folder, look for Data Visualization.qvw

there is an example, this

1.png

View solution in original post

3 Replies
Not applicable

Do no about the line but the rest of it should be a simple scatter plot if you have aggregated values for FY.

Regards

R

kuba_michalik
Partner - Specialist
Partner - Specialist

Seems doable with a scatter chart, example attached. Key is, you need two dimensions in chart. First would be year, second is something else (customer for example) - if you need only one line, it can be a calculated dimension with a constant value. Now I know what those options were for

maxgro
MVP
MVP

in your Qlik installation folder, look for Data Visualization.qvw

there is an example, this

1.png