Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nvijay5757
Creator
Creator

i need to display wired frame

Hi i need to display the chart looks like wired frame.
i have tried using straight table with linear gauge but any other option for Good looking the chart

My requirement is exactly the below

nvijay5757_0-1639895731654.png

can anyone help me in this.

to display the chart for Min,Max,Min1,Max1--Average(with scale also display)

if Max1 > Target we mark one Reference line.

 

Batch Level Min Max Min1 Max1
B Level1 29.0 30.0 27.0 37.0
B Level1 19.5 20.5 18.0 28.0
B Level2 19.5 21.5 18.0 28.0
B Level2 22.0 23.0 18.0 28.0
B Level2 19.5 21.0 18.0 28.0
B Level3 16.0 16.5 10.0 20.0
B Level3 12.0 13.0 11.0 15.0
B Level1 12.5 13.0 11.0 15.0

 

1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

The closest I could get to your use case scenario in QlikView is by following the steps below:

  1. Create a new Chart with Chat Type set to Line Chart
  2. Add Batch as Dimension
  3. Add the following Expressions as Measure:
    • =Avg(Min)
    • =Avg(Min1)
    • =Avg(Max)
    • =Avg(Max1)
  4. Under Style > Orientation set Orientation to "Horizontal
  5. Under Presentation > Legend un-check "Show Legend
  6. Under Presentation > Line/Symbol Settings set Line Width to 10pt
  7. Under Axes > Expression Axes check the "Hide Axis"
  8. Under General un-check the option "Show Title in Chart"
  9. Under Dimensions > Settings for Selected Dimension un-check option "Show Legend"
  10. Under Caption un-check the option "Show Caption"
  11. Under Colors change all the first 4 colors to black
  12. Create new Line/Arrow object with background color transparent, orientation Horizontal and Line Width set to 3pt
  13. Adjust the size of the object so it only takes from the fist point and goes to the last point
  14. Create new Line/Arrow object with background color transparent, orientation Horizontal and Line Width set to 1pt
  15. Adjust the object so that it takes the same size as the first one but it is also extended from both sides

Here is the result:

 

Please keep in mind that this was an attempt to make the visualization look as much as possible to the one that you have mentioned in your description. There, might be other ways to implement the same outcome, however if you would like to have more control over implementing this natively, the you can submit a feature request [1].

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 

 

---

[1] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

2 Replies
Andrei_Cusnir
Specialist
Specialist

Hello,

 

The closest I could get to your use case scenario in QlikView is by following the steps below:

  1. Create a new Chart with Chat Type set to Line Chart
  2. Add Batch as Dimension
  3. Add the following Expressions as Measure:
    • =Avg(Min)
    • =Avg(Min1)
    • =Avg(Max)
    • =Avg(Max1)
  4. Under Style > Orientation set Orientation to "Horizontal
  5. Under Presentation > Legend un-check "Show Legend
  6. Under Presentation > Line/Symbol Settings set Line Width to 10pt
  7. Under Axes > Expression Axes check the "Hide Axis"
  8. Under General un-check the option "Show Title in Chart"
  9. Under Dimensions > Settings for Selected Dimension un-check option "Show Legend"
  10. Under Caption un-check the option "Show Caption"
  11. Under Colors change all the first 4 colors to black
  12. Create new Line/Arrow object with background color transparent, orientation Horizontal and Line Width set to 3pt
  13. Adjust the size of the object so it only takes from the fist point and goes to the last point
  14. Create new Line/Arrow object with background color transparent, orientation Horizontal and Line Width set to 1pt
  15. Adjust the object so that it takes the same size as the first one but it is also extended from both sides

Here is the result:

 

Please keep in mind that this was an attempt to make the visualization look as much as possible to the one that you have mentioned in your description. There, might be other ways to implement the same outcome, however if you would like to have more control over implementing this natively, the you can submit a feature request [1].

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 

 

---

[1] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
nvijay5757
Creator
Creator
Author

Hi,

the same chart can we display in Qlik sense, is it possible or not.

if possible can you please tell me how?