topic Re: Date filtering in QlikView

Date filtering

Mon, 18 Jun 2012 10:18:29 GMT

Hi,

I was filtering Data using date, In which I manage to do that, but I want a table to only show the filtered data.

Please see that attached file, where I am filtering using Daily, so I want my table to only show the daily data.

Re: Date filtering

Mon, 18 Jun 2012 10:40:35 GMT

Hi,

Remove the expression Filter from the table and replace the previous expression of Total Amount with this ->

if(date(Test_Date,'DD-MM-YYYY')=vFilterTime,Sum(Amount) + Sum(Amount2) + Sum(Amount3),0)

this will give you only today's data. Is this your requirement?

Regards

Apurva

Re: Date filtering

Mon, 18 Jun 2012 10:50:55 GMT

Hi, Apurva

I am trying to avoid using many "IF" statements, since I have other many calculations still to be added, The use of many "IF" statements makes my qvw too slow since I am loading milions of rows

Re: Date filtering

jagan — Mon, 18 Jun 2012 11:04:07 GMT

Hi,

Please check attached file for solution, I added one new column in script to get date in number format.

Hope this helps you.

Regards,

Jagan.

Re: Date filtering

Wed, 20 Jun 2012 12:16:48 GMT

Hi Jagan

sorry for replying so late, Thank you very much for the solution, it works perfectly and now the qwv is super fast, thanks again

Regards

Edzi

Re: Date filtering

Tue, 10 Jul 2012 07:50:22 GMT

Hi Jagan

Asking if you can help me again with this?

From the qvd you sent me how can I make the daily button to only display data starting from 6:00 instead of startin from 00:00

Kindly regards

Edzi

Re: Date filtering

jagan — Tue, 10 Jul 2012 08:53:02 GMT

Hi,

Check attached file for solution.

Regards,

Jagan.

Re: Date filtering

Tue, 10 Jul 2012 09:20:20 GMT

Thanks Jagan

It worked, thabk you very much.

Kind regards

Edzi

Re: Date filtering

Thu, 02 Aug 2012 12:44:58 GMT

Hi Jagan

The last time I posted this I was using an excel file as my data source, and you added

"Num(Test_Date) AS TestDateNum," on the date column,

how can I make it work using SQL table for my data? Im not able to return the columns when I reload if I include that column as you sudgested.

Thanks in advance

Edzi