Select option

[#1]

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 Title	Phase	Start Date	End Date
A	End	1/8/2017	1/8/2017
A	PEP	1/1/2016	31/3/2016
A	Start	1/8/2016	31/7/2017
A	Tender	1/4/2016	31/7/2016
B	End	1/7/2018	1/7/2018
B	PEP	1/1/2016	31/3/2016
B	Start	1/8/2016	30/6/2018
B	Tender	1/4/2016	31/7/2016
C	End	1/1/2016	1/1/2016
C	Start	10/3/2015	31/12/2015
C	Tender	10/11/2014	9/3/2015
D	End	1/6/2016	1/6/2016
D	Start	1/1/2016	31/5/2016
D	Tender	1/9/2015	31/12/2015
E	End	1/12/2019	1/12/2019
E	PEP	1/6/2017	31/8/2017
E	Start	1/1/2018	30/11/2019
E	Tender	1/9/2017	31/12/2017
F	End	1/7/2016	1/7/2016
F	PEP	13/3/2014	12/6/2014
F	Start	13/10/2014	30/6/2016
F	Tender	13/6/2014	12/10/2014
G	End	1/12/2016	1/12/2016
G	PEP	1/6/2015	31/8/2015
G	Start	1/12/2015	30/11/2016
G	Tender	1/9/2015	30/11/2015
H	End	1/12/2016	1/12/2016
H	PEP	1/1/2016	31/3/2016
H	Start	1/8/2016	30/11/2016
H	Tender	1/4/2016	31/7/2016

[Wuzhong_Zhu]

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

[#3]

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.

[#4]

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

[#5]

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

[#6]

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

[#7]

Okay, Noted! Thank you so much