Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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

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

LocationgovesamplingdtsQUES
chanderia12102/22/201620
dr1422/21/201630
HP55331/1/201640
chanderia11772/22/201540
dr20442/21/201550
HP33301/1/201560

so in one bar chart i am showing

Dimension:Location

Expression: firstsortvalue(gove,-dts)

Untitled.png                              

on selecting any bar i  will get this:

Untitled.png

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

1 Solution

Accepted Solutions
kunkumnaveen
Contributor III

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

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);

14 Replies

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

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

kunkumnaveen
Contributor III

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

i do known  thats why i said on clicking 

only that particular bar chart

vikasmahajan
Honored Contributor III

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

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

kunkumnaveen
Contributor III

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

Untitled.png

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

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

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

kunkumnaveen
Contributor III

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

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

try like this

Crosstable(Name,value,5)

LOAD

     sampling,

     dts,

     QUES,

Location,

     gove,

FROM

(ooxml, embedded labels, table is Sheet1);

kunkumnaveen
Contributor III

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

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

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

Community Browser