Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

link a expression chart with detail

Hi, is it possible to link my bar chart with project detail?

Bar chart detail:

dimension: Phase

measure: Count(distinct {$<[Start Date] = {"$(='>=' & Date(monthstart(today(2)), 'D/M/YYYY') &'<=' & Date(monthend(today(2),2), 'D/M/YYYY'))"}>} [Project Title])

Capture.PNG

I would like to know how to link the bar chart with project detail, for example, when i click on PEP, there will be 8 project detail appearSmiley Happy

thanks in advance

7 Replies
baz
New Contributor

Re: link a expression chart with detail

Hi Lingling

All the fields should be associated automatically during loading. Not sure if I understand you problem correctly, but you may want to put a table chart with all the fields as dimension.  The way Qix engine works is kinda different from traditional database/data warehouse, think about filtering instead of selecting.

Cheers

Siva_Sankar
Honored Contributor

Re: link a expression chart with detail

Find the attached example

Not applicable

Re: link a expression chart with detail

Hi Lingling,

I'm not sure if i understand your question correctly as well. If your data model is linked correctly, when you click on any bar, having a Project details listbox next to it, it'll filter accordingly.

Or you can create a drill down dimension, when you click on a bar, it'll drill down the bar graph by Project details

balrajahlawat
Esteemed Contributor

Re: link a expression chart with detail

Create a Drill Group which would be having two dimension like:

Project -> Project Title

Properties - > Dimension -> Edit Groups(Bottom Left) -> Select Drill Down ->Name a Proper Drill Group -> Add Dimension -> Project & Project Title..

Once you create it, add this drill group as a dimension..

Creating Cycle and Drill Groups

Qlik Sense - Drill-down Group Dimension (video)

Not applicable

Re: link a expression chart with detail

Hi, I am not sure how to phrase it. When I click on the 'PEP' for example, it only filter the "Phase" field, what i want is filter on 'PEP' as well as the "start date"

nizamsha
Valued Contributor

Re: link a expression chart with detail

You can create a drill down if my   understanding is correct

Not applicable

Re: link a expression chart with detail

Sorry, I might not explain my question properly. This is an example of my data set, when I click on the 'PEP' bar in the bar chart, I should expected to see 8 lines in the table. But I think due to formula issue in the measure, the filter does not work out properly. Thus, I am trying to solve the issue.

Project TitlePhaseStart DateEnd Date
AEnd1/8/20171/8/2017
APEP1/1/201631/3/2016
AStart1/8/201631/7/2017
ATender1/4/201631/7/2016
BEnd1/7/20181/7/2018
BPEP1/1/201631/3/2016
BStart1/8/201630/6/2018
BTender1/4/201631/7/2016
CEnd1/1/20161/1/2016
CStart10/3/201531/12/2015
CTender10/11/20149/3/2015
DEnd1/6/20161/6/2016
DStart1/1/201631/5/2016
DTender1/9/201531/12/2015
EEnd1/12/20191/12/2019
EPEP1/6/201731/8/2017
EStart1/1/201830/11/2019
ETender1/9/201731/12/2017
FEnd1/7/20161/7/2016
Community Browser