topic Re: label Issue in QlikView

label Issue

NavinReddy — Sat, 22 Aug 2015 07:33:37 GMT

Hi Good Morning to All,

i have one straight table like this ,here problem is circled one is label

the next sheet i created one more table having all detail information about different business

when i click that label i just want to move the detail sheet

how can i make label as click format

Best Regards,

Niranjan

Re: label Issue

petter — Sat, 22 Aug 2015 08:43:36 GMT

You can have a trigger that checks if only one of the problems are selected. If one single problem is selected then you can hide the current sheet and show the sheet with the details.

This is a little bit "risky" since there could possibly be other events than just clicking on the label that leads to only one label being selected - so the logic is not fail-safe.

The steps:

1) Create two variables named vShowMain and vShowDetails and assign the number 1 to each of them

2) Create the two sheets - one for the Details and one for the Overview (unless you already want to use your main sheet)

3) The Overview sheet needs a Show Sheet - Conditional that you can specify on the properties of the sheet like this:

vShowMain

4) The Details sheet needs a Show Sheet - Conditional

vShowDetails

5) Go to the Settings / Document Properties and the Triggers tab and select your field in

the Field Event Triggers listbox then press the On Select - Add Action(s) Button and add two actions

of type External , Set Variable:

variable: vShowMain

value: If( Count(DISTINCT TheLabel) = 1 , 0 , 1 )

variable: vShowDetails

value: If( Count(DISTINCT TheLabel) = 1 , 1 , 0 )

6) On the Details sheet you need some way of deselecting the single label so you can "leave" the sheet.

It could be made by having a button with this Action:

Selection / Select in Field:

Field: TheLabel (use the actual field that is displaying the label ... not the column header)

Re: label Issue

NavinReddy — Sat, 22 Aug 2015 09:22:29 GMT

Hi Petter,

Many Thanks for your reply

i have 60 expression if can i select any one of expression from first chart

the same expression details i want to show in my details sheet

but label i can't able to select

if its required please find the my attachement

Many Thanks,

Niranjan

Re: label Issue

petter — Sat, 22 Aug 2015 09:37:57 GMT

Are you saying that you can't select any value in the label column? Are you using a Straight Table or a Pivot Table?

Re: label Issue

NavinReddy — Sat, 22 Aug 2015 09:46:47 GMT

Yes exactly Sorry its pivot table

when i click this label second sheet i m using same label expression for detail view

the same way for 60 expression every label i want to show the detail view

any way can i make label Click format

Best Regards,

Niranjan

Re: label Issue

petter — Sat, 22 Aug 2015 09:56:30 GMT

So it works for you?

Re: label Issue

NavinReddy — Sat, 22 Aug 2015 10:02:41 GMT

im not able to do that i attached sample app

can you please show me how we can achieve this problem

Many Thanks

Niranjan

Re: label Issue

petter — Sat, 22 Aug 2015 10:25:32 GMT

I am sorry - I don't know of any way to achieve this in a Pivot Table that is embedded in a container seven times. With one single Pivot Table you could have a button for each of the rows to the right left of the first column. But with seven pivot tables there is no way that I know of to be able to detect which of the container objects are visible.

The only solution to this as far as I know is to abandon the container and emulate the container appearance with buttons instead and hiding and showing each pivot table. Then you could achieve this with buttons and detecting which of the pivot tables are currently active.

Re: label Issue

NavinReddy — Sat, 22 Aug 2015 10:36:20 GMT

if can we achieve with one pivot table i will remove using Container object

above im using one list box if you select any value from list box details view sheet will appear

there im showing percentages also in list box, if nothing will work im planning to use that technique

Best Regards,

Niranjan

Re: label Issue

petter — Sat, 22 Aug 2015 10:39:11 GMT

I think I can give you an example based on your Sample Application. But I am running out of time now for an appointment. Maybe I will be able to have a look at it later today or tomorrow.

Re: label Issue

NavinReddy — Sat, 22 Aug 2015 10:48:43 GMT

Thank you i will wait for your reply

Re: label Issue

petter — Sat, 22 Aug 2015 11:20:24 GMT

This should give you an idea on how to implement it I hope:

Re: label Issue

NavinReddy — Sat, 22 Aug 2015 12:03:54 GMT

But here i have some problem some chart having many expressions i have to scroll down

again client they dont want buttons (actually good idea but here it wont work)

Thank you so much for your support

Niranjan, Many Thanks