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 |