topic Re: select set of dates in listbox in QlikView

select set of dates in listbox

Tue, 17 Mar 2015 04:50:04 GMT

Hi All,

I would like to see set of dates in listbox (Date) get selected up on the selection of list of values of list box(Days).

If possible pls share it with a working example..with the sample data given below.

listbox(Date ) Listbox(Days)

01-01-2015 Past 2 days --- when this get selected it should Select....04-01-2015 & 03-01-2015

02-01-2015 Past 3 days --- when this get selected it should Select....04-01-2015 , 03-01-2015 & 02-01-2015

03-01-2015

04-01-2015

Thanx in advance

Regards

Krishna

Re: select set of dates in listbox

aveeeeeee7en — Tue, 17 Mar 2015 05:06:18 GMT

Go through the below threads:

http://community.qlik.com/thread/125400

Regards

Av7eN

Re: select set of dates in listbox

Tue, 17 Mar 2015 05:15:32 GMT

Hi Av7en,

Thnx for the reply ....Actually I am looking for a list box selection but not buttons...

Regards

Krishna

Re: select set of dates in listbox

rwunderlich — Tue, 17 Mar 2015 05:24:20 GMT

Take a look at

Qlikview Cookbook: Date Grouping http://qlikviewcookbook.com/recipes/download-info/date-grouping/

for an example of assigning values like "last 2 days" and "last week" to a listbox.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: select set of dates in listbox

Tue, 17 Mar 2015 05:45:46 GMT

Thnx Rob,

It is very informative ....

Regards

Krishna

Re: select set of dates in listbox

timanshu — Tue, 17 Mar 2015 06:33:17 GMT

Hi Krishna,

Look for attached file. This works perfectly.

Re: select set of dates in listbox

Tue, 17 Mar 2015 06:37:45 GMT

Hi Timanshu, This is really awesome....thnq very much..

Regards,

Krishna

Re: select set of dates in listbox

Tue, 17 Mar 2015 06:53:54 GMT

Hi,

May I know the logic behind this work ? Beacoz, Both the dates and the Duration table has no connection and on what condition it filters? Please explain

Regards

Lathaa

Re: select set of dates in listbox

timanshu — Tue, 17 Mar 2015 07:11:01 GMT

Hi Lathaa,

It works on the basis of Trigger. With the help of trigger , we can select any field available in qlikview independent of any linking.

Re: select set of dates in listbox

varunvarma — Tue, 17 Mar 2015 07:14:51 GMT

Hi Virmani,

Please explain the logic, how it is working. Thank you.

Regards,

Varma.

Re: select set of dates in listbox

Tue, 17 Mar 2015 07:21:44 GMT

How do I can see your trigger action?

I didnt see any code in Document properties-> Trigger

Point me to Correct direction

Regards

Lathaa

Re: select set of dates in listbox

Tue, 17 Mar 2015 07:51:57 GMT

Hi Timanshu,

Does Triggers have any limitation on converted date formats...as I'm unable to get this as per my requirement.

Regards,

Krishna

Re: select set of dates in listbox

timanshu — Tue, 17 Mar 2015 08:27:21 GMT

Hi Varun,

I am using trigger. If Duration is Selected, then trigger fires, which takes Dates from MaxDate - Duration +1 to MaxDate. Then I separate values by '|' and put them in ( ) which is condition in trigger to select multiple fields.

example :-

Selecting Past 2 Dates :

MaxDate - Duration +1 gives 4/1/2015 - 2+1 -> 3/1/2015

MaxDate gives 4/1/2015

Final :

( 3/1/2015| 4/1/2015)

this will select 2 values in date field

Re: select set of dates in listbox

timanshu — Tue, 17 Mar 2015 08:30:43 GMT

Hi Krishna,

No there is no Limitation of Date formats. But You should refer a date field in same format where ever used as they declared for correct comparison.

Attach qvw if it still does not resolve.

Re: select set of dates in listbox

varunvarma — Tue, 17 Mar 2015 08:39:38 GMT

Thank you. I got it.

Re: select set of dates in listbox

Tue, 17 Mar 2015 08:48:01 GMT

Hi Timanshu,

Please find the attached qvw..help me in resolving this ...

Regards

Krishna

Re: select set of dates in listbox

timanshu — Tue, 17 Mar 2015 10:45:17 GMT

Hi Krishna,

You have to define Year too in Date Field to Make this work. Any Format of Date but with All 3 parameters are acceptable.

Change the format in script to mention year and attach qvw. As I cant reload.

Re: select set of dates in listbox

Tue, 17 Mar 2015 11:25:52 GMT

Hi Timanshu, please find attached file... which is the source of qvw.....

Regards

Krishna

Re: select set of dates in listbox

timanshu — Tue, 17 Mar 2015 12:16:29 GMT

Hi,

File and script are different.

Script;

LOAD Name as Job,

Scheduled,

[Start Time],

[End Time],

Status,

[Avg RunTime],

[42074],

[42073],

[42072],

[42071],

[42070],

[42069],

[42068],

[42067],

[42066],

[42065],

[42064],

[42063],

[42062],

[42061],

[42060],

[42059],

[42058],

[42057],

[42056],

[42055],

[42054]

.......

These fields are not in excel.

Re: select set of dates in listbox

Tue, 17 Mar 2015 13:16:40 GMT

Hi Timanshu,

When we load data from excel, the format of the date field is [42054], [42055],that is why I'm converting that particular fields to date format i.e to 19-feb, 20-feb..etc..using this function (Date(PurgeChar(Date,'[]'),'DD-MMM') ....the days get added on day to day basis..If you load the data from excel..you will see the same fields... please let me know if you need anything more..

Regards

Krishna