Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All Group Members,
This is bharat, i am new to qlikview.i face some of requirement like this ,,can some body tell me,how to do this requirement and how to face these type of requirements in future,,
my requirement is like this ,,this is my input, have date and amount per perticular months as a fiscal year as well and need output as a cummulative amount ..in that input some months dont have a amount ,in those months i need '0' as amount...please tell me how to get this one . i am sending you my requirement as Exel file, please find in attachments..
thanks in advance.
bharat.m
To start with:
Go to edit script - Choose Tables Files - Find your excel file - Choose embedded labes, and choose ur sheet (in this case input).
How you got all your data loaded in.
Then you can right click in your sheet and select new chart, and then select straight table - In here you can select Date as dimension and sum(amount) on expression
Under Presentation your uncheck Supress zero values (then you will get all 0 values from your dataset)
Then you make a new expression with sum(amount) again.
But this check under the expression box, you mark full accumlation. This will solve your problem i think
And here is what it looks like
im not sure on how to start it all over again, when you get a new year, but maybe someone else know.
This atleast should get you more than half way
You can add the missing months in the script and calculate the cumulative per year too. See comm81300_1.qvw.
Or you can use an AsOf table. This is a bit more complicated but a lot more flexible. See comm81300_2.qvw.
Your good!! I also learned something
But isnt your rolling 12 months wrong? At the end it substracts? Now thats relevent for the topic.
Thanks for u r reply tjetjetje,
but i didn't get responce like u r posted,instead of that i got some other response,
and one more is after completion of year 2011,next january onwords that amount should not add to the above amount,,the amount should add to the next coming months of 2012 like
01-01-2012 11 11
01-02-2012 22 33
01-03-2012 33 66 , like this way i need ,,
thanks in advance
Gysbert it sound that "You are a quick fix" well .