topic straight table with barchat selected values in QlikView

straight table with barchat selected values

Tue, 07 Jun 2011 08:54:07 GMT

hi ,

i have one straight table and one barchat.the bar chat max visible number is 4 and with bar char have x-axis scrollbar so i need display the only 4 values in straight table which are i seleted in bar chat remaining values are need to hide in straight table

How?

Thank you

Re: straight table with barchat selected values

Miguel_Angel_Baeyens — Tue, 07 Jun 2011 09:09:42 GMT

Hello,

You can create a variable vMaxBarToDisplay in the Settings menu, Variable Overview. Then you can use that variable in a slider object so the user is able to select how many bars wants to see, and use the same variable as the limit in both the bar chart (chart properties, Prsentation tab, Dimension Limitations, Max Visible Number) and the straight table (chart properties, Presentation tab, Max Number):

=vMaxBarToDisplay

Note that the sort criteria must be the same for both charts, otherwise you will see actually two values, but they may be different.

Check the attached application.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

straight table with barchat selected values

Tue, 07 Jun 2011 09:50:16 GMT

hi miguel,

thanks for replay but iam not using slider object iam using x-axis scorll bar in Barchart,

so i didnot get

Thank you.

straight table with barchat selected values

sparur — Tue, 07 Jun 2011 10:01:46 GMT

hello, sunny

Can you explain why you don't want to use a slider?

I think, Miguel suggested a simple solution for you. If I'm wrong please give us more clarifications of your task.

otherwise, you can use both - slider (for manage variable) and scroll in bar chart

straight table with barchat selected values

Tue, 07 Jun 2011 10:12:03 GMT

hi sparur,

miguel explanation was fine and it is working but i dont want to use another slider object .

now i am using barchart with x-axis scrollbar with max visible number is 4.i have one straight table so

what the values are (4)appear in bar chat only those values must display in straight table.

frist i select 4 values only those values display in straight table,if i scroll the scroll bar,values will be change so

previous values need to hide from straight table and display with new values.

Thank You

straight table with barchat selected values

sparur — Tue, 07 Jun 2011 10:19:22 GMT

I'm afraid create an error.

but I think, that it's impossible. We can't understand which values should be visible when use scroll.

straight table with barchat selected values

Tue, 07 Jun 2011 10:53:33 GMT

Thanks for ur response sparur and miguel,

now iam using slider so problem is sloved.

i will keep in touch