topic Re: LABEL Pivot table in QlikView

LABEL Pivot table

souadouert — Thu, 27 Apr 2017 10:14:08 GMT

Hello,

I'm looking for a solution to not display label in the table pivot

Re: LABEL Pivot table

Frank_Hartmann — Thu, 27 Apr 2017 10:17:01 GMT

Just paste a space sign here

hope this helps

Re: LABEL Pivot table

Anil_Babu_Samineni — Thu, 27 Apr 2017 10:17:14 GMT

Mau be use Space instead of Name. or you want to hide Cell for label

Re: LABEL Pivot table

souadouert — Thu, 27 Apr 2017 10:23:45 GMT

the cell for label anil

Re: LABEL Pivot table

Frank_Hartmann — Thu, 27 Apr 2017 10:27:08 GMT

then try custom format cell and adapt the label colour to the background to make it invisible:

Re: LABEL Pivot table

antoniotiman — Thu, 27 Apr 2017 10:28:33 GMT

In Text Color

ARGB(0,0,0,0)

Regards,

Antonio

Re: LABEL Pivot table

Anil_Babu_Samineni — Thu, 27 Apr 2017 10:32:05 GMT

That's not a good practice and there is no feature such . I didn't go that approach instead of we have good and neat. I am just assuming, those are three objects

Seems, You want to make one object instead of 3 objects why can't you make single object.

Look here Re: Pivot problem for adding another dimension

Learn from and Breadcrump seems this. Starts from Right loveisfail <-- stalwar1‌ <-- kush141087‌

Re: LABEL Pivot table

souadouert — Thu, 27 Apr 2017 10:47:21 GMT

The problem that the three dimensions depend on the other, the region has several

Zone the Zone has several agency,

In the case where the dim is region: in the exp I elmine in the expression set lib_region

exp region:

round(sum({<LIB_ZONE, YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,SITUATION_PRODUIT,REAL_BANQUEADISTANCE.PROD_BAD={"1"}>}REAL_BANQUEADISTANCE.STOCK_NOMBRE_BAD)),

exp zone:

round(sum({< YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,SITUATION_PRODUIT,REAL_BANQUEADISTANCE.PROD_BAD={"1"}>}REAL_BANQUEADISTANCE.STOCK_NOMBRE_BAD)),

Re: LABEL Pivot table

Anil_Babu_Samineni — Thu, 27 Apr 2017 13:02:22 GMT

Oh okay, Can you provide sample to look for some other help