Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I want automated report as given in screenshot.

Hi all,


I want automated report for the month of April, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec, Jan,Feb,Mar, MTD, YTD and yesterdays data. in one table.

I have made a report for the above requirement but after every month I have to change the number  in expression.

eg:

Sum( {<Date={">=($=Date(MonthStart(AddMonths(Today()-1,-10)),'DD-MM-YYYY'))

                         <= ($=Date(MonthEnd(AddMonths(Today()-1,-10)),'DD-MM-YYYY')) "}

          >}

     GWP)


Every next month I have to change the number i.e ( I have to adjust the no 10 accordingly.)

PLease help.


Please find the attachment for reference.

PhotoGrid_1520099924374.jpg


4 Replies
Anonymous
Not applicable
Author

Can you please send the QVW and excel which you had sent before this reply.

Anonymous
Not applicable
Author

Please help ,

I have made this report,

I want to make automated.

vishsaggi
Champion III
Champion III

I did not upload any qvw file? Not sure what you talking about?