Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

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,

Tags (2)
8 Replies

Re: Graph in straight table

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

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)
Partner
Partner

Re: Graph in straight table

somethinh like this should appear

Capture.PNG

laddu_927
Valued Contributor

Re: Graph in straight table

Capture.PNG

may be you can use minicharts.

Partner
Partner

Re: Graph in straight table

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

laddu_927
Valued Contributor

Re: Graph in straight table

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

Partner
Partner

Re: Graph in straight table

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.

laddu_927
Valued Contributor

Re: Graph in straight table

Like this??

Partner
Partner

Re: Graph in straight table

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