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.
