I am relatively new to QlikView and have been developing a model for my company. I believe I have a good understanding of the basics but today I came across a challenge which I don't know how to tackle.
I have a table i which I show the debt of our clients in a date which is selected in a calendar object which store de value in a variable called vFechaCorte.
So, for any given date I can have the state of company's debt at that time, sorted by amount and client.
I woul like to chart those values across different dates. In other words I would like to have a chart showing the evolution of debt in different dates (given by the variable vFechaCorte)
I'm pretty sure the end result you're after is possible.
But a variable can have only one value at a time. So I don't understand how you want to use the variable to show data from different dates at the same time. Can you post a small qlikview document that illustrates the problem?
I have a database in which all movements from our clients are recorded (i.e sell invoices and payments).
In QlikView, I created a table in which I can show the account of our clients in any date. Lets call that date vCutDate
For example:
Client Movement Amount Date
A Invoice 100 01-25-2016
B Invoice 200 01-27-2016
A Invoice 50 02-15-2016
A Payment -100 02-25-2016
B Payment -200 03-10-2016
Sow if I set vCutDate for 02-20-2016 then the amount due, at that date, for A will be 150 and for B will be 200.
If vCutDate is 02-28-2016 then the amount due for A will be 50 and for B will be 200
If vCutDate is 04-01-2016 then the amount due for A will de 50 and for B will be 0
I would like to chart the amount due for each client day-by-day for the whole year. Where the X Axis will be vCutDate and the Y Axis will be the amount due.
In other words I need to run the table for each date of the year and plot echa poin (amount due) in a chart.
I still don't understand how you want to use one variable to show data from different dates at the same time. If vCutDate is used for the x-axis then if you give the variable vCutDate one value (a variable can have only one value at a time) then your x-axis will have only one data point.
