Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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
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.
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
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
Hi,
Check attached file for solution.
Regards,
Jagan.
Thanks Jagan
It worked, thabk you very much.
Kind regards
Edzi
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