topic Re: Graph in straight table in QlikView

Graph in straight table

rassanbekov — Mon, 12 Jun 2017 10:11:49 GMT

Hello!

Please help to construt the graph within the table

I have data on Accounts receivable balance over the period. I need to show graphically openning balance, closing balance and to-date balance. For example,

Header 1	Header 2	Header 3	Header 4
A	40	20	15
B	15	22	88
C	50	10	100

Let's say, in "Header 5", there should be graphical movement of abovestated balances.

Kind regards,

Re: Graph in straight table

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:20:09 GMT

It would better if you provide sample output in tabular format for [Header 5]

Re: Graph in straight table

rassanbekov — Mon, 12 Jun 2017 10:30:26 GMT

somethinh like this should appear

Re: Graph in straight table

Anonymous — Mon, 12 Jun 2017 10:33:25 GMT

may be you can use minicharts.

Re: Graph in straight table

rassanbekov — Mon, 12 Jun 2017 10:39:09 GMT

It's clear that I can use minibars but I have no idea how to tailor to this particular case described. Because I need to show the points on graphs of several fields...

Re: Graph in straight table

Anonymous — Mon, 12 Jun 2017 10:41:40 GMT

Can you share exact requirement so that we can try to help you

Re: Graph in straight table

rassanbekov — Mon, 12 Jun 2017 10:45:12 GMT

The requirement as follows

I have several fields with figures as stated above "headers 2,3,4". I need to construct minibar in header "header 5" as I have attached pic. Please describe the formula to fulfill this.

Re: Graph in straight table

Anonymous — Mon, 12 Jun 2017 10:55:52 GMT

Like this??

Re: Graph in straight table

rassanbekov — Mon, 12 Jun 2017 12:07:46 GMT

Yes, but I cannot understand how to make "value" field. I have input data as follows:

I need somehow make crosstable?

Could you please help how to make "value" field from

[BB, Сальдо на начало],

[EB, Сальдо на конец],

[Сальдо на конец].

since I have different sources...

LOAD	Index,
	[Company name],
			[BB, Сальдо на начало],
		[EB, Сальдо на конец],

FROM [0_ISS\Processed\ProcPopulation 31.12.2016.xlsx] (ooxml, embedded labels, table is Sheet1);

Directory;

Load * , If(Оплачено=0,0,1) as Flag;

LOAD	Index,
		Company as [Company name],
		Region as Region,
		[Сальдо на начало],
		Начислено,
		Оплачено,
		[Сальдо на конец],

FROM [0_ISS\Processed\ProcPopulation 01.01.2017-20.05.2017.xlsx]

(ooxml, embedded labels, table is Sheet1);