Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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.
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
Hi Nhu, May i know where to find the standard listbox? Thanks
Just drag the dimension to the sheet, it behaves like standard listbox
Okay, Noted! Thank you so much