Discussion Board for collaboration on QlikView Layout & Visualizations.
How do I bring in a graph with the dimension month and the expression Sum ([amount billed]) where the value to the previous month?
May Today we want him to bring me the value only until the end of April
Go to Solution.
I would make a variable vLastMonth =Date(MonthsEnd(1,Now(),-1),'DD/MM/YYYY')
Then use set analysis similar to Bharathi above:
//Remove any date selections if they are affecting your data set
//apply the filter to your date field
Hi try this
I hope this is helpfull to you
Thank you! in a few days I will have to test!