topic Re: QlikView App development question in QlikView

QlikView App development question

Mon, 04 Aug 2014 17:52:23 GMT

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:

	Region	A	B	C	D	E
Case	Division	10	20	30	40	50
1		100	200	0	0	0
2		0	0	300	0	0
3		0	0	0	400	500

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

	Region	A	B
Case	Division	10	20
1		100	200

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):

	Region	A	B	CB	D	E
Case	Division	10	20	30	40	50
1		100	200	0	0	0

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:

	Region	A	B	CB	D	E
Case	Division	10	20	30	40	50
1		100	200	0	0	0
2		0	0	300	0	0
3		0	0	0	400	500

Thanks

Jag

Re: QlikView App development question

joshabbott — Mon, 04 Aug 2014 17:59:29 GMT

Hello!

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

Re: QlikView App development question

Mon, 04 Aug 2014 18:42:23 GMT

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,

	Region	A	B	C	D	E	-	-	-	-
Case	Division	10	20	-	-	-	30	40	50	-
1		100	200	-	-	-	-	-	-
-	-	-		0	0	0	0	0	0	0
Total		100	200	-	-	-	-	-	-	-

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

	Region	A	B	C	D	E
Case	Division	10	20	30	40	50
1		100	200	-	-	-
Total		100	200	-	-	-

Thanks

Jag

Re: QlikView App development question

tobias_klett — Mon, 04 Aug 2014 18:54:19 GMT

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