Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

Vertical Reference Lines work around needed

Hello Qlikers,

Do we have option to get Vertical Ref line? Sample attached

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
19 Replies
Anil_Babu_Samineni
Author

Andy - The idea you made may helps further rek's not for one. My business is different than what and where we are. But, to understand clear let's have a look in attached.

So, We have one dimension which periodically animation with Hours:Minute variation. So, I have 3 measures with Area plot. Now i would like to present with some vertical line. So we thought to get in in case if our standard time may cross from 4PM to 6 PM the line should move. That is what we have in View but not sure Why Sense not yet developed. In 2017 we got many versions with Patches none of them under developed this future.

Omar - Does Lines with Bar (Combo) can allot with Area plot?

Anyway, Would you like to share few inputs the same mto

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ogster1974
Master II
Master II

The combo chart approach allows you to use the legend to give context but personally I think the coloured line looks cleaner and if you made it an area chart the effect would be shown even clearer.   You could also add an image to explain the reason for the change in colour.

OmarBenSalem
Partner
Partner

Try to use this extension Anil(u can control the bar width, I'll let u play with it to adjust it to ur needs):

Qlik Branch

example of use:

Capture.PNG

Anil_Babu_Samineni
Author

I've done this earlier(but useful) (The moment they are not happy with Extension). But, Now they are Okay to use.

Drawbacks by me not from product

1) If i want to disable popup and mouse over, Option not available (May be My eye power battery low)

2) The title graph looks "JS chart by anCharts" should disable, Even this is not available

3) The content of Bar Text should cover different color text.

Capture.PNG

Advantages

All are good, Until unless we can customize the JS and HTML script to make more better (This part i can handle)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Michael_Tarallo
Employee
Employee

Hi Anil / et al - I have entered this into our internal ideation system - the current work-arounds or extensions options are the way to go at this time.

Regards,
Mike Tarallo
Qlik
simondachstr
Luminary Alumni
Luminary Alumni

We'll work on that!

Anil_Babu_Samineni
Author

omarbensalem , Will you get a chance to look ?

1st and 2nd resolved by using my own custom JS. 3rd is pending

Again, I got few more drawbacks

1) Can we change X-Axis and Y-Axis Line (From Black - Gray)?

2) I would like to use Static Step like Min, Max and Step as QlikView?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni
Author

Finally, Deserve using Native one without Vertical Reference Line and i realized there is some challenges using this box. So, I thought to convey them using Native and fine for them too. The only challenge even native can not be done for 3 Plot areas and One metric using plane line chart. So, We have some work around and achieved that using ARGB() ... So, I am going to close my response only

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

anthime_biau
Contributor
Contributor

Hello

Without any extension I have tried to resolve your problem.

As i don't know how to add more information into the mousehover label, i chose to split information into a table and into a combochart

Image.PNG

Hope it will be helpful !

Qlik-Developer
Creator
Creator

ganginenivarsha_0-1602260802648.png

expecting like above chart.

How can we get max value of scale for reference bar.i need the expression for max value of scale?

i need to create a bar reference for current date, so i used below formula:

if(date=today(),measure)

but bar is scaling till line i need full till max of scale.

ganginenivarsha_1-1602260853078.png