topic Re: FromDate & ToDate from one date column in QlikView

FromDate & ToDate from one date column

sasqliksense — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Greetings..

I have a table with 12 columns out of with one date field(AUDDATE) is there, I need to derive FromDate and ToDate from this column and need to filter the data based on this. Please help

Thanks

Sas

Re: FromDate & ToDate from one date column

sdmech81 — Mon, 06 Feb 2017 11:49:40 GMT

Hi,

Plss send the few sample rows frm AUDDATE column.

Sachin

Re: FromDate & ToDate from one date column

sunny_talwar — Mon, 06 Feb 2017 12:25:15 GMT

May be look at this?

Selecting Arbitrary Date Ranges

Re: FromDate & ToDate from one date column

sasqliksense — Mon, 06 Feb 2017 12:30:00 GMT

Hi Sachin,

Data looks like below

AUDID	AUDSUB	AUDUSER	AUDROLE	AUDACTION	AUDDATE
1	xx	aaa	SU	Completed	2017-02-06 00:0000.0000
2	xx	aaa	MG	Pending	2017-02-06 00:0000.0000
3	xx	aaa	NU	Completed	2017-02-06 00:0000.0000
4	xx	aaa	NU	Completed	2017-02-05 00:0000.0000
5	xx	bbb	SU	Pending	2017-02-05 00:0000.0000
6	xx	bbb	SU	Pending	2017-02-04 00:0000.0000
7	yy	bbb	SU	Pending	2017-02-04 00:0000.0000
8	yy	bbb	MG	Completed	2017-02-03 00:0000.0000
9	yy	cccc	MG	Completed	2017-02-03 00:0000.0000

Re: FromDate & ToDate from one date column

Anil_Babu_Samineni — Mon, 06 Feb 2017 12:37:18 GMT

If possible, Please provide output for me

Re: FromDate & ToDate from one date column

sasqliksense — Mon, 06 Feb 2017 12:45:58 GMT

Hi Sunny,

I am new to QlikSense, the link you given is explaining how to do that in QlikView. please let me know how to do the same in QlikSense v3.1SR4

Re: FromDate & ToDate from one date column

sasqliksense — Wed, 22 Feb 2017 11:41:12 GMT

Hi All,

I am able to accomplish this task by using API "SenseDataRangePicker-Master" extension available here on Qlik Branch.

Regards

Sas