Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sparur
Valued Contributor II

Need advice with the creation of specific chart.

Hi, all.

Could you give me an advice for resolving my problem...

I want to create an One Line chart with 2 expressions:

1) Trend of % by specific Company (I do It).

2) Trend of rank same Company.

(for more details see an attachments)

Finally, I want a chart like Figure:error loading image:

where

a blue line is a trend of percentage Company A by Quarter

and

a red line is a trend of Rank Company A by quarter.

Each of the lines attached to the axis Y. Blue to the left axis and red to the right.

Who has any idea how to implement it?

May be in one chart it's impossible?

I will be a glad to listen to any ideas.[Smiley Very Happy] Thank for all.

6 Replies
shumailh
Contributor III

Need advice with the creation of specific chart.

Use the below property and find the attachement,

Regards,
Shumail Hussain

shumailh
Contributor III

Need advice with the creation of specific chart.

Attachement

sparur
Valued Contributor II

Need advice with the creation of specific chart.

Hi, thank for your answer.

But your expression for calculating Rank isn't correct.

I need trend of rank(company A) in comparison with other company by Quarter. That is the maximum rating must be equal to 3 (because the number of companies of all 3).

as shown in screenshot.

sparur
Valued Contributor II

Need advice with the creation of specific chart.

Does somebody has any ideas yet? Smile

shumailh
Contributor III

Need advice with the creation of specific chart.

I think you need to try to define rank in edit script mode.

Regards,
Shumail Hussain

sparur
Valued Contributor II

Need advice with the creation of specific chart.

Oh. no.

It's not flexible variant. Sad

But if nothing else is found, it probably will.

Regards, Anatoly.

Community Browser