Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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, thanks:)

 

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
6 Replies
Wuzhong_Zhu
Former Employee
Former Employee

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
Author

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
Author

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
Author

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

Not applicable
Author

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

Not applicable
Author

Okay, Noted! Thank you so much