Apply Threshold on Bands and 2 dimensions and threshold should be on all the bands not based on first band

amita1621 — Wed, 01 Aug 2018 11:58:06 GMT

Reinsurer name	Month	Section	Branch	Billed Status	Bands	Amt
A	Feb			Billed	0-90	1000050
A	Jan			Unbilled	91-180	50050
A	Jan			Billed	181-365	50050
A	Jan			Billed	>365	50050
B	Jan			Billed	0-90	50000
B	Jan			Unbilled	91-180	50000
B	Jan			Unbilled	181-365	50000
B	Jan			Unbilled	>365	50000
	Jan			Unbilled	0-90	1000000
	Jan			Unbilled	91-180	50000
	Feb			Billed	181-365	50050
	Feb			Billed	>365	50000
	Feb			Billed	0-90	50000
	Feb			Billed	91-180	50050
	Feb			Billed	181-365	50000
	Feb			Billed	>365	50000
	Feb			Unbilled	0-90	50000
	Feb			Unbilled	91-180	50050
	Feb			Unbilled	181-365	50000
	Feb			Unbilled	>365	50000

Month	Feb
Section	(All)
Billed Status	Billed

Sum of Amt		Bands
Reinsurer name	Contact Name	0-90	91-180	181-365	>365	Grand Total
A	AA	1000050				1000050
(blank)	(blank)	50000	50050	100050	100000	300100
Grand Total		1050050	50050	100050	100000	1300150

I want to replicate this format in qlikview.

The sample data and pivot are pasted above.

The filters are to be applied rest i want values from bands as '0-90' amt should be greater than 1lakh , '91-180' amt >50000 and '181-365' >50000 and '>365' > 50000

While i am trying the greater than applies to only '0-90 ' remaining band values comes based on '0-90'

I want to apply a condition where i can apply conditions on all bands and also i need 2 dimensions also.

Please help?

Month	Feb
Section	(All)
Billed Status	Billed

Sum of Amt		Bands
Reinsurer name	Contact Name	0-90	91-180	181-365	>365	Grand Total
A	AA	1000050				1000050
(blank)	(blank)	50000	50050	100050	100000	300100
Grand Total		1050050	50050	100050	100000	1300150

topic Apply Threshold on Bands and 2 dimensions and threshold should be on all the bands not based on first band in QlikView

Apply Threshold on Bands and 2 dimensions and threshold should be on all the bands not based on first band