topic Re: Chart according to a changing variable in QlikView

Chart according to a changing variable

Fri, 14 Oct 2016 16:32:04 GMT

Hi:

This is my first post to the community

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)

Is it possible?

Thanks!!

Re: Chart according to a changing variable

Gysbert_Wassenaar — Tue, 18 Oct 2016 07:26:02 GMT

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?

Re: Chart according to a changing variable

Tue, 18 Oct 2016 11:17:20 GMT

Hi Gysbert:

Thanks for your answer.

Let me explain myself better:

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.

Is it possible?

Re: Chart according to a changing variable

Gysbert_Wassenaar — Wed, 19 Oct 2016 06:55:32 GMT

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.