Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

No Data to Display - Product Category by Sales from Different Excel Tables

I have Excel tables that have data as follows:

Sales Data:

Account      Invoice Number      Invoice Date Year Month Product Quantity Invoice amount

1815           3626226                12/30/2013    2013 12     148     224          $35,204.40

Product Data:

Product   Product code    Product category      Product category code         Standard price

Jescie     252                  5                             Music and entertainment      $183.00           

Variable cost    Gross margin    Year

$54.90             128                  2010

Customer Data:

Customer name                Country                  Region       Customer Number

Ac Mattis Semper LLC      United Kingdom      GNM          1606

Sales Budget:

Year    Month     Account      Product code     Budget

2010    1           1038            250                   72,201

I would like to create a bar chart showing Product Category by Invoice Amount (Sales), but I keep getting 'no data to display'. I have set the dimension as Product category code and set Invoice amount to dollars format. I am not sure what I am doing wrong.

Thank you in advanced for help

1 Reply
Not applicable

I have just figured out that when I try exactly the same thing for sales budget per product category instead it works. Does anyone know what could be going on?