Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Select option

Hi, I would like to have a bar char counting the number of project is in the "PEP", ' Tender', 'Start', 'End' phase in the next X month. and i have a option (Radio or checkbox or list) to chose whether is 3 month or 6 month or 1 year. I have no idea how to do it,  Please advance me, thanksSmiley Happy

 

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
FPEP13/3/201412/6/2014
FStart13/10/201430/6/2016
FTender13/6/201412/10/2014
GEnd1/12/20161/12/2016
GPEP1/6/201531/8/2015
GStart1/12/201530/11/2016
GTender1/9/201530/11/2015
HEnd1/12/20161/12/2016
HPEP1/1/201631/3/2016
HStart1/8/201630/11/2016
HTender1/4/201631/7/2016
Tags (2)
6 Replies
baz
New Contributor

Re: Select option

Hi Lingling

You may have a filter pane with dimension month(endTime) or month(endTime)-month(Now())

if your endTime was not loaded as time stamp, you may want to convert it using timestamp# function

Not applicable

Re: Select option

Hi WuZhong,

Thanks for reply, my main concern is that whether can I have a option (Radio or checkbox or list) to chose whether the calculation is for 3 month or 6 month or 1 year.

Not applicable

Re: Select option

Hi Lingling,

Whether you can download extension for Radio or checkbox from Qlik branch.

Or if you use the standard listbox from Sense, you can create a dummy table with 3 values: 3 mth, 6 mth & 1 year.

So when you select, your expression will put in IF statement

If(GetFieldSelections(Time) = '3 mth', <exp1>, etc...)

Or you can use variable to make it easier

Not applicable

Re: Select option

Hi Nhu, May i know where to find the standard listbox? Thanks

Not applicable

Re: Select option

Just drag the dimension to the sheet, it behaves like standard listbox

Not applicable

Re: Select option

Okay, Noted! Thank you so much