topic AW:Help me to create a line chart in QlikView

Help me to create a line chart

Thu, 28 Apr 2011 11:55:49 GMT

Hello Guru's,

I have a problem in Qlikview, this is the scenorio the report is created in a daily basis.

There are some calculated expressions like count (Invoice Number) and Sum (sales).

the dimention is Date().

What I am looking is I would like to create a line chart based on date, I would like to store the values on the date and to create a line chart.

How to save the expression values of count of invoice and sum of sales with current date and create a trend chart.

Date	Count of Invoice	Sum of Sales
01.02.2010	100	512222
02.02.2010	120	653333
03.02.2010	180	543332
04.02.2010	78	5612330

Can anyone advise me, it will be helpful for me..

Regards

Joe

AW:Help me to create a line chart

brenner_martina — Thu, 28 Apr 2011 13:02:15 GMT

Hi Joe,

see attached file.

AW:Help me to create a line chart

Thu, 28 Apr 2011 13:45:57 GMT

Hello Martina,

Thanks for your reply, what I am looking is the values which are are all dynamic one, the today's value and the next days values and so on are should be stored in a file and based on that I have to draw a line chart.

If its not clear I will send you more detail.

Regards,

Joe