Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rassanbekov
Partner - Contributor
Partner - Contributor

Graph in straight table

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 1Header 2Header 3Header 4
A402015
B152288
C5010100

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

Kind regards,

8 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rassanbekov
Partner - Contributor
Partner - Contributor
Author

somethinh like this should appear

Capture.PNG

Anonymous
Not applicable

Capture.PNG

may be you can use minicharts.

rassanbekov
Partner - Contributor
Partner - Contributor
Author

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

Anonymous
Not applicable

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

rassanbekov
Partner - Contributor
Partner - Contributor
Author

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.

Anonymous
Not applicable

Like this??

rassanbekov
Partner - Contributor
Partner - Contributor
Author

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

LOADIndex,
[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;

LOADIndex,
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);