Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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
i do known thats why i said on clicking
only that 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
this wat i am looking only on clicking that particular 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
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);
try like this
Crosstable(Name,value,5)
LOAD
sampling,
dts,
QUES,
Location,
gove,
FROM
(ooxml, embedded labels, table is Sheet1);
how to write expression
=FirstSortedValue({<quality={gove}>},-dts)
i am missing something
can u help me
could you let me what your trying to achieve with this expression