Filtering a Pivot Table Data

PRS — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have below urgent requirements, Please help me.

Requirement1

TRevenue	TMargin	TMargin%
32,393	17529	54%
23,145	12,258	47%
22,735	8,175	36%
Some Data	Some Data	37%
Some Data	Some Data	36%
Some Data	Some Data	54%
Some Data	Some Data	100%
Some Data	Some Data	45%

Here i want to add two filters using multiboxes TMargin%< and TMargin%>

-->Drop down values in T Margin % < filters should be 5, 10, 15, 20, 25.

-->Drop down values in T Margin % > filters should be 75, 80, 85, 90, 95.

-->Also there should be an option to view all values in the report. That is not applying any of the above two filters

Requirement2:

I have a table like below

Contarct No	GLDate
111	20160831
112	20160808
113	20160804
114	20160808
115	20160809
116	20160605
117	20160409

I want to adda a filter using multibox on ‘GLDate’. The drop down values should be > 2Weeks, > 1 Month and > 2 Months. GL Date should be compared with today’s date to identify whether it is > 2 weeks or > 1 month etc.

Can anybody help me regarding these requirements.

Thanks,

Rajasekhar

topic Filtering a Pivot Table Data in QlikView

Filtering a Pivot Table Data