Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
here is a problem I am facing, look at the provided QVW. (Inline Load)
I tried to make an expression, but it is not working. There are two problem.
1) When I select One Month and two years, I want to have 2 Bars - 2016 2 and 2017 2. Now I have bars for each year and each month till selected month.
2) numbers are incorrect, since 2017 2 has to have 40 (20 + 20).
Please help me.
Thank you.
Hello,
Thank you. You are right, March is the 1 month if I sort by Load Order. How come? We load master calendar from database where it is sorted. Any suggestion how this can be fixed? Thank you very much!
Are you using QlikView 12 or above? If you are, then try this
Aggr(RangeSum(Above(Sum({<Year, Month>}Sales), 0, RowNo())), Year, (Month, (NUMERIC)))
No, unfortunately 11.
Thank you.
Then may be you sort the Month field in the script... Something like this
FactTemp:
LOAD Year,
Month,
Year*100 + Month as YearMonth
Resident Fact
Order By Year, Month;
And then use this expression
Aggr(RangeSum(Above(Sum({<Year, Month>}Sales), 0, RowNo())), Year, YearMonth)