FromDate & ToDate from one date column

[sasqliksense]

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

[sdmech81]

Hi,

Plss send the few sample rows frm AUDDATE column.

Sachin

[sunny_talwar]

May be look at this?

Selecting Arbitrary Date Ranges

[sasqliksense]

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

[Anil_Babu_Samineni]

If possible, Please provide output for me

[sasqliksense]

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

[sasqliksense · Accepted solution]

Hi All,

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

Regards

Sas