Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

QlikView App development question

Test_Table:
LOAD * INLINE [
Case, Division,Region, Amount
1,10,A,100
1,20,B,200
2,30,C,300
3,40,D,400
3,50,E,500
]
;

and we want to visualize it in a pivot table. Without any selections made, the intermediate output is as follows displaying every single data point with the missing values displaying as zeros:

RegionABCDE
CaseDivision1020304050
1100200000
20030000
3000400500

However when a selection for Case is made, only certain Regions and Divisions where the data points are not missing are displayed:

RegionAB
CaseDivision1020
1100200

The ask is for all Regions and Divisions to display so that it would look like this when Case 1 is selected (as mocked up in Excel):


RegionABCBDE
CaseDivision1020304050
1100200000


I’ve tried for some time to make this happen using various techniques but to no avail. Is there a simple way for this to happen without putting in dummy values to force all Regions and Divisions to display?


The closest we could get was the following using set analysis but we don’t want Cases 2 and 3 to display at all:


RegionABCBDE
CaseDivision1020304050
1100200000
20030000
3000400500


Thanks

Jag


3 Replies
Highlighted
Creator III
Creator III

Re: QlikView App development question

Hello!

For your dimensions of Region and Division, check under 'Properties'->'Dimensions', Show all Values.  Attaching a sample

Highlighted
Not applicable

Re: QlikView App development question

Hi Josh -

Thanks for the quick reply, i tried but the output visual is not as expected. I get below format when i set SHow Values for Region and Division,

RegionABCDE----
CaseDivision1020---304050-
1 100200------
--- 0000000
Total 100200-------

Is there any other way to represent the data in below format.

RegionABCDE
CaseDivision1020304050
1 100200---
Total 100200---

Thanks

Jag

Highlighted
Partner
Partner

Re: QlikView App development question

Hi Jag,

make sure your dimension for 30,40,50 is not NULL but C,D,E.

Than you only have to go to Presentation and mark suppress zero values.

Hope this helps
Tobias