Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

I am creating a forecast report in which i have to display data as follows:

Hello Everyone,

I am creating a forecast report in which i have to display data as follows:

Header 1Header 2Header 3
A1value from databasevalue from database
B1value from databasevalue from database
C1value from databasevalue from database
D1Calculated ValueCalculated Value
E1Calculated ValueCalculated Value
F1Calculated ValueCalculated Value
G1Calculated ValueCalculated Value
h1A1's value of header3A1's value of header 4 and so on..

where A1,B1,C1,D1,E1,F1,G1,h1 are the fields of the database in which they are present in different order.

I want to display it like above, where my A1, B1,C1 are direct values,

and D1,E1,F1,G1 are calculated value using A1,B1,C1 and one another field which is not displayed here.

and h1 is the A1's value of next header.

What should be my approach of selecting a chart and work in a desired way.

Thanks in advance.

and Regards

1 Reply

Re: I am creating a forecast report in which i have to display data as follows:

Can you post an excel file with a table with source data and a table that shows the result?


talk is cheap, supply exceeds demand
Community Browser