Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart according to a changing variable

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!!

3 Replies
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
Not applicable
Author

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?

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand