Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mithun_j
Partner
Partner

Pivot Chart calculation based on Filter selection

I have a requirement where i display a below pivot chart and a filter in QV report.

The column "No of units sold" in the chart depicts the total no of units sold irrespective of product type

Assume Sony had sold 4 tv, 5 mobile phones, 6 Camera, and 5 home theater during the month of jun 2018 in Asia. The count sums to 20 and is displayed in the pivot chart.

Now i have a requirement where if the user select "Television" from "Product Type" filter, then my pivot chart should automatically count only the no of television units sold in June 18, so the value should be displayed as 4 and not as 20 since the product Type filter is selected.

Please show us some pointers on how to implement the filter selection in the pivot chart.

  Product Filter

Product type
Mobile phones
Television
Camera
Home Theater

   

Sales Report - Pivot chart

Time PeriodJun-18May-18Apr-18
RegionCompanyNo of units soldNo of units soldNo of units sold
AsiaSony204080
LG503040
Samsung70075150
0 Replies