Hi ,
I have data like below
| Region | Prod | Date | Status |
| A | ABC | 2-May | 1 |
| A | ABC | 3-May | 1 |
| A | IJK | 4-May | 0 |
| A | LMO | 5-May | 1 |
| B | ABC | 2-May | 1 |
| B | DEF | 3-May | 1 |
| B | IJK | 4-May | 0 |
| C | LMO | 2-May | 1 |
| C | ABC | 3-May | 1 |
| C | DEF | 4-May | 0 |
Need to display 3 tabels /charts like below
Step 1: If i clik on any values in below table it should remain as it is ,ie it should be there until last step irrespective of any selections made in step2/step3
| Row Labels | Sum of Status |
| A | 3 |
| B | 2 |
| C | 2 |
| Grand Total | 7 |
Step 2 : After cliking on any values (Ex : i clik on value 3) from above ,below table should pop up and display in new table as below
| Region | A |
| Row Labels | Sum of Status |
| ABC | 2 |
| IJK | 0 |
| LMO | 1 |
| Grand Total | 3 |
Step 3 : clik on any value on any value form above table ( Ex: clik on 2 ), below table should pop which shows date .
Table in step 2 should be replaced with below one
| Prod | ABC |
| Region | A |
| Row Labels | Sum of Status |
| 2-May | 1 |
| 3-May | 1 |
| Grand Total | 2 |
Can you please help how this can be implemented in qlikview
