Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
For a report that I am making I need the following:
I have a graph, which shows our sales over the weeks, and I want to show a cummulative measure which sums from week 1 to the current week in the graph
, see image:
The Blue line is the WTD, I only calculated it in my dataset, which makes the query very slow. Is there a way to let Qlikview calculate the WTD, and how can I do that? When I need to make a WTD measure in my dataset for every cumulative measure, the performance will be dramatic.
Thanks!
Try to use
MAKEWEEKDATE function in qlikview
for this you should have week no and year.
HTH
Sushil
Hi Sushil,
This is not what I mean. I want QlikView to calculate the cummulative graph, so it has to sum week 201201 to the current week in the graph. e.g. for week 201210 it has to sum week 201201 to 201210, for week 201212: 201201-201212. In year 2013 it has to start summing as of week 201301.
No one with an answer? 😞
Hi,
You can simply create a new field against your data. Meaning consider you have following data.
Sales from 01/01/2011 till date and your script looks something like this.
load Date, Sales From xyz.
then try doing like this.
load Date,Weekstart(Date) as WeekStartDate,Sales From xyz.
Now use the WeekStartDate in your chart.
Hope the idea is clear.
Regards,
Kaushik Solanki
Can you upload your sample application
No I can't since it contains confidential information.
ok Whats your expression?
None...The graph needs to do something like this in MDX:
sum({YTD(Calendar.Year.Currentmember, Calendar.CurrentMember)} Sales)
Calendar.Year.Currentmember?
Calendar.CurrentMember?