Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

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
Specialist
Specialist
Author

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

View solution in original post

14 Replies
avinashelite

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
Specialist
Specialist
Author

i do known  thats why i said on clicking 

only that particular bar chart

vikasmahajan

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
kunkumnaveen
Specialist
Specialist
Author

Untitled.png

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

avinashelite

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
Specialist
Specialist
Author

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

avinashelite

try like this

Crosstable(Name,value,5)

LOAD

     sampling,

     dts,

     QUES,

Location,

     gove,

FROM

(ooxml, embedded labels, table is Sheet1);

kunkumnaveen
Specialist
Specialist
Author

how to write expression

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

i am missing something

can u help me

avinashelite

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