topic Re: how to select multiple fields when click only one particular bar chart in QlikView

how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 06:18:21 GMT

Hello All

How to select two diff fields on clicking a bar chart,wat i mean is

let say if i got data like below

Location	gove	sampling	dts	QUES
chanderia	12	10	2/22/2016	20
dr	1	42	2/21/2016	30
HP	55	33	1/1/2016	40
chanderia	11	77	2/22/2015	40
dr	20	44	2/21/2015	50
HP	33	30	1/1/2015	60

so in one bar chart i am showing

Dimension:Location

Expression: firstsortvalue(gove,-dts)

on selecting any bar i will get this:

so what i am looking when i select only this bar chart i need the field gove should also getselected

what should i need to do achieve this task ...

thanks

naveen

Re: how to select multiple fields when click only one particular bar chart

avinashelite — Fri, 01 Jul 2016 06:21:41 GMT

Did you tried with the field event triggers in the document properties ?? using the field event triggers you can achieve this but make a note " Triggers are not based on the chart , its based on the fields you select so if you select the field Location anywhere in the dashboard it will select the field GOV "

Hope this helps you

Re: how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 06:25:23 GMT

i do known thats why i said on clicking

only that particular bar chart

Re: how to select multiple fields when click only one particular bar chart

vikasmahajan — Fri, 01 Jul 2016 06:26:13 GMT

Below bar chart you can create a straight table with gove field with expression put 1 , on layout conditional you can put condition if (getselectcount(Location)='HP',1,0) and display straight table.

Hope this resolve your issue.

Vikas

Re: how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 06:26:39 GMT

this wat i am looking only on clicking that particular chart .....

Re: how to select multiple fields when click only one particular bar chart

avinashelite — Fri, 01 Jul 2016 06:28:19 GMT

we don't have such feature in Qlikview to restrict the triggers to a particular chart ...you could try with Macro then you could achieve this

Re: how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 06:39:01 GMT

actually i am having one bar chart for each filed i mean,

one for gove and one for sampling

so will it work if i bring these two fields under one filed by applying cross table function

let say new field name :quality

which is a group of both gove and sampling

Dimension:Location

exp: firstsortvalue({<quality=gove>},-dts)

if this is correct can you tell me plz how to write cross table function for this fields

LOAD Location,

gove,

sampling,

dts,

QUES

FROM

(ooxml, embedded labels, table is Sheet1);

Re: how to select multiple fields when click only one particular bar chart

avinashelite — Fri, 01 Jul 2016 06:45:36 GMT

try like this

Crosstable(Name,value,5)

LOAD

sampling,

dts,

QUES,

Location,

gove,

FROM

(ooxml, embedded labels, table is Sheet1);

Re: how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 06:51:02 GMT

how to write expression

=FirstSortedValue({<quality={gove}>},-dts)

i am missing something

can u help me

Re: how to select multiple fields when click only one particular bar chart

avinashelite — Fri, 01 Jul 2016 07:19:09 GMT

could you let me what your trying to achieve with this expression

Re: how to select multiple fields when click only one particular bar chart

sunny_talwar — Fri, 01 Jul 2016 07:29:36 GMT

You can probably explore alternate state to do this for this specific chart.

Re: how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 07:30:28 GMT

finally i achieved what i am looking by applying cross table function...

one last help plz

i am trying to show a text box which should enabled only when

location=1 and quality='gove'

other then that it should be hidden

so in text box layout

i tried by write this

=getselectcount(location)=1 and how to write the other expression

Re: how to select multiple fields when click only one particular bar chart

sunny_talwar — Fri, 01 Jul 2016 07:31:00 GMT

This expression

=FirstSortedValue({<quality={gove}>},-dts)

is not right because your have not specified what are you finding the first sorted value of?

=FirstSortedValue({<quality={gove}>}FieldName,-dts)

Re: how to select multiple fields when click only one particular bar chart

kunkumnaveen — Fri, 01 Jul 2016 07:32:16 GMT

yes ur correct,i sorted that

finally i achieved what i am looking by applying cross table function...

one last help plz

i am trying to show a text box which should enabled only when

location=1 and quality='gove'

other then that it should be hidden

so in text box layout

i tried by write this

=getselectcount(location)=1 and how to write the other expression

Re: how to select multiple fields when click only one particular bar chart

sunny_talwar — Fri, 01 Jul 2016 07:32:57 GMT

May be like this:

=GetSelectedCount(location)=1 and quality = 'gove'