topic Re: Legend Issue in QlikView

Legend Issue

Anil_Babu_Samineni — Thu, 21 Dec 2023 20:19:15 GMT

Hello,

I am trying to adjust the Width of the graph. If i check the option Suppress Zero Values from Presentation tab for this graph. I am getting some thing different on Legendary.

For reference, Please find attachment..

Can you please help me for this..!

Re: Legend Issue

sasikanth — Wed, 08 Jun 2016 09:46:56 GMT

Hi,

Your attachment contains 3 charts what exactly you wan to achieve

can you please elaborate a little more

Re: Legend Issue

awhitfield — Wed, 08 Jun 2016 09:47:48 GMT

Sorry, not too sure what you mean, but you do seen to have 3 charts overlapping each other

Is this what's causing the issue? Ah just spotted that you have candidates without a type or other details:

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 10:00:25 GMT

Sasi,

in that second graph

1) Why Legendary showing three boxes. Green , Red, Blue

2) If, I placed my mouse to the second graph the pop-up values are not showing. Because, there is one text box. Can you please help me these two ???

- Anil

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 10:00:52 GMT

Andrew,

Please find above reply

Re: Legend Issue

sasikanth — Thu, 21 Dec 2023 20:19:30 GMT

hi,

I have created a new chart and its working with out any issues including popup ,

PFA,

else

please do check suppress Null values OR suppress zero values check box in presentation tab to remove null

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 10:41:23 GMT

Sasi,

Good Job.

But, i want to show two graphs for first page. and then when i click the second graph i want to show third graph..

This scenario, i used the Text box for clicking. If i click the text box here showing third graph..

I know that is not the correct way. If you know the butterfly, can you please create that graph for me..

Re: Legend Issue

sasikanth — Wed, 08 Jun 2016 10:50:21 GMT

HI,

write a conditional statement for 3rd graph

=if(getSelectedCount(Type)>0,1,0)

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 11:04:36 GMT

Sasi,

Did you understand my problem / you want to explain more..

If possible, Please share what ever you did on my fresh qvw..

See, i want to show hires and leaver. hires is one graph and leavers is another graph.

After that, if i click on leavers i want to hide hires graph and must be leaver graph placed to the hires graph. So, I did that already..

But, here i am facing problem. Which i mentioned before conversation for 2 Points...!

Re: Legend Issue

sasikanth — Wed, 08 Jun 2016 11:19:31 GMT

HI,

i could sense the below points from your reply,

1) You are not selecting any thing in Levier (chart2) but still the action should work to show the same chart as chart 3

2) you managed with a text object and working well if you select chart 2 then chart 3 covering everything ,but

Here if i want to see chart 1 and 2 again then where do you select in chart 3 ?

so you don`t want to apply triggers based on selection in field values ?

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 11:28:08 GMT

Sasi,

Yes you are correct.

That's why i am asking you. Can you please create that and then share it to me with Triggers...

So that, i can access here and i apply on my live...

Please help me.

Re: Legend Issue

sasikanth — Wed, 08 Jun 2016 11:45:04 GMT

hi,

we can write actions based on the values selected in Fields not on Objects i hope you understand ,

please let me know your exact scenario not the visualization part, what you want to achieve through this

so that i can help you on this with another approach if possible

Re: Legend Issue

Anil_Babu_Samineni — Thu, 21 Dec 2023 20:17:30 GMT

Sasi,

I have excel like below..

I take two graphs here. So, Client want to show single graph only. If i want to move one graph client want to move whole graph. But, here i am facing problem like if i move one graph the graphs are split it two graphs...

1) Hires graph

For reference :

Graph 1 (Dimensions are Start Date ( from iv Recruiting data) and Expression is count(candidate {iv Recruiting data})

2) Leaver graph

Graph 2 (Dimensions are Drill Down {ExitDate, BU/Department, Job Level, Job Title - From HR HC Leavers (named), Expression is Count(Name of Leaver) } ). Here i want to show like image

So, here when i click on second graph like Exitdate I want to show third graph with the drill down is BU/Department, Job Level, Job Title - From HR HC Leavers (named)

So i want to create one graph with these two graphs...

------------------------------

Client don't want to create any buttons here. When ever we click on second graph she want to hide first graph only. And then she want to show the second graph replace to first graph

Please help me....

Re: Legend Issue

sasikanth — Thu, 21 Dec 2023 20:20:07 GMT

HI,

PFA,

I have implemented the trigger based on the exit year,

select Year on chart 2 to see chart 3, clear the selection to revert back.

Might be helpful

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 13:28:03 GMT

Sasi,

1) If once click the 2nd Graph it showing 3rd graph. Why third graph stack is not working and mean time. If i click on third graph. Again i want to go to back for that 3rd graph (Drill down) -- It is not working?

2) Can you please let me know how 3rd graph came while click the 2nd Graph without text object..

Re: Legend Issue

sasikanth — Wed, 08 Jun 2016 15:22:01 GMT

hi,

Please Observe clearly , stacked Bars are displaying in 3rd graph,

also , you can drill down in 3rd chart no need to go for 2nd chart again .

no need to click on anything , just clear the selections the 3rd chart will be hide.

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 15:54:01 GMT

Sasi,

Yeah i understand what you are trying to say.

But thing is, In the third graph i want to show like below...

Re: Legend Issue

sasikanth — Wed, 08 Jun 2016 16:43:51 GMT

hi,

current application is also showing the same,

Re: Legend Issue

Anil_Babu_Samineni — Wed, 08 Jun 2016 16:46:15 GMT

Sasi,

For first and second graph are two graphs, Right?

Is there any chance to create one graph?

Re: Legend Issue

Anil_Babu_Samineni — Thu, 21 Dec 2023 20:20:18 GMT

SAsi,

PFA

I am fine foe this, Can you please do for me. The graph width is not suitable. I want to show same as above graph width and below graph are similar(For ref, Please find image).

And whenever trying to show the third graph there showing only voluntary but i want to show stacked with Voluntary & In voluntary from all drill downs...