Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
joshabbott
Creator III
Creator III

Hello!

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

Not applicable
Author

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

tobias_klett
Partner - Creator II
Partner - Creator II

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