I have one excel file and based on this file data i need to create days bucket
i have a column date1 where using this date1 column , i need to create 30,60,90 days bucket. When i select one date at filter, based on that ,from that particular date, i need to get dates and related buckets.
example, if select jan 1 2019, then i should get dec 1 2018 to 31 dec 2018 dates and other bucket as 30 days for this related dates
But when i select date1 column at qliksense report, i am getting data but when i try to get as date1-1the no data displayed for me. Even when tried as date(date1,'MM/DD/YYYY') then also no data.
When i try today() at report, i got current date but when try to get previous date as today()-1, then also i dont get any data.
Can any one please suggest as how can i move forward on this.
OP created a new thread Here, but I don't think I understand the issue well enough to answer it. I did give it a shot, but @Anil_Babu_Samineni is still trying to help and I am sure he will be able to help the OP out.
You have marked an answer as a solution, so you can just leave it be and no-one will probably post anything to this thread anymore unless if they have a follow up question.
When a question is marked with an answer they will be displayed
