How to restrict measure columns for dimension values in Pivot table ?

parikshit88 — Wed, 18 Jul 2018 03:07:31 GMT

Hi Qlik Expertise,

I have one requirement where I want to restrict few columns as per dimension values from pivot table.

will come to scenario directly:

I want to implement Expected Result.jpg (See attached) format into qlikview pivot table.

We have Financial and Customer Type and their sub type respectively. Apart from this in the same table I want to show data for YTD.

I am able to create this table structure but my concern is

1) I want to hide Target, Total Rating and Remark column from Financial and Customer Type

2) I want to hide Target, Actual, %, Weight, Rating columns from YTD.

Note - Currently YTD, Financial and Customer are coming from One column i.e. Type

similarly Final Rating is coming from Sub Type along with Food Prod, Annual Cost values.

I have attached two images. 1st Current Result Date.jpg is the currently which I am getting data into pivot table structure

where as I want the the expected result as per image Expected Result.jpg

Please help me here to hide measure columns as per dimension values.

topic How to restrict measure columns for dimension values in Pivot table ? in QlikView