Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dashboard Help

Hi all,

I want to create simple dashboard in tabular format like below:

Any idea from anyone how can I create this format in QV?

Help appreciated.

Total for DayCumulative for
  month
Daily
  variance to Plan
Cumulative
  variance to Plan
Number%Number%
Daily Sales
- Total 3001000-105%-32-3%
- Product 1 1001100-207%-35-4%
- Product 2 1001200-305%-38-5%
- Product 3 1001300-4010%-40-4%
Total Amount
- Total 15001500-105%-32-3%
- Product 1 5002000-207%-35-4%
- Product 2 5002500-305%-38-5%
- Product 3 5003000-4010%-40-4%

Regards

Mak

3 Replies
its_anandrjs

Yes you can create a straight table for this and with different formulas with different expression do you have sample data for this.

Not applicable
Author

Hi Anand,

Many thanks for your reply. I am sorry, I don’t have any sample data right now.

But I am very curious to know how can we set expressions displayed in two dimensions like vertical and horizontal as given example?

Regards

Mak

vijetas42
Specialist
Specialist

Hi Makarand,

You can use straight table or convert it to cross table as per your requirement and in that you can select expression total in expression tab and also check Totals in first row in presentation tab

I hope this will help you...

Thanks and Regards,

Vijeta Sharma