topic Re: In Qliksense for Date picker How to add/syntax for OR condition to get required Data . in App Development

In Qliksense for Date picker How to add/syntax for OR condition to get required Data .

chinni — Thu, 28 Apr 2022 11:49:55 GMT

Hyy

I am using Date Picker for picking the From &To date to get only the required data from the Table to download.

Here in Date Picker In Advanced setup I had given Timestamp field column.

For that I have used Syntax -> =date(floor(my_TimeStamp_Field)

So my concern is that Date Picker should consider another column along with the TimeStamp field..

So I tried like this.. =date(floor(my_TimeStamp_Field)) or (I_Column)

Here I'm not getting whether the syntax for OR condn i am used is proper or not..

But it's not working...

can anyone help...

Thanks much....

Re: In Qliksense for Date picker How to add/syntax for OR condition to get required Data .

vinieme12 — Thu, 28 Apr 2022 14:52:10 GMT

As below

=date(RangeMax(floor(Timestampfield),floor(Other field)))

Use RangeMax() or RangeMin() as required

Re: In Qliksense for Date picker How to add/syntax for OR condition to get required Data .

chinni — Thu, 28 Apr 2022 16:53:12 GMT

will try and let u know..

Re: In Qliksense for Date picker How to add/syntax for OR condition to get required Data .

chinni — Fri, 29 Apr 2022 09:27:24 GMT

If we want to use two TimeStamp field Columns in Date picker...then what was the Syntax for that..

And I need to know one more...

If One is Timestamp field and other is some Report field in Date picker...

Previously this Report field is in format yyMM but need to change the format to- yyyy-MM-DD. (where only Date should be constant) like these pattern 2020-02-17, 2020-03-17....

Can anyone help with this issue..