Hi All,
I need help in showing last 5 periods based on current period value in Qlikview Pivot Chart.
Dimensions -> District, Period
Exp -> Num((Sum({<Year=,Month=,Period=,Start_Date=,Start_Date={">=$(=Date(Max(Start_Date)-85))<=$(=Max(Start_Date))"}>}f_appt_set)
/
Sum({<Year=,Month=,Period=,Start_Date=,Start_Date={">=$(=Date(Max(Start_Date)-85))<=$(=Max(Start_Date))"}>}f_engaged)
),'#,##0.#%')
| District | 24Sep2020-8Oct2020 | 9Oct2020-21Oct2020 | 22Oct2020-4Nov2020 | 5Nov2020-18Nov2020 | 19Nov2020 - 2Dec2020 |
| D1 | 50% | 20% | 30% | 90% | 45% |
| D2 | 40% | 60% | 70% | 80% | 8% |
| D3 | 25% | 8% | 30% | 20% | 10% |
| D4 | 10% | 81% | 72% | 66% | 25% |
I have a button "Below 10%" --> When I click this button, it should only give me D2 and D3 records...how to acheive this?
My current logic is giving me
If(
(Num((Sum({<Year=,Month=,Period=,Start_Date=,Start_Date={">=$(=Date(Max(Start_Date)-85))<=$(=Max(Start_Date))"}>}f_appt_set)
/
Sum({<Year=,Month=,Period=,Start_Date=,Start_Date={">=$(=Date(Max(Start_Date)-85))<=$(=Max(Start_Date))"}>}f_engaged)
),'#,##0.#'))<=0.10,
Num((Sum({<Year=,Month=,Period=,Start_Date=,Start_Date={">=$(=Date(Max(Start_Date)-85))<=$(=Max(Start_Date))"}>}f_appt_set)
/
Sum({<Year=,Month=,Period=,Start_Date=,Start_Date={">=$(=Date(Max(Start_Date)-85))<=$(=Max(Start_Date))"}>}f_engaged)
),'#,##0.#%'))
| District | 24Sep2020-8Oct2020 | 9Oct2020-21Oct2020 | 22Oct2020-4Nov2020 | 5Nov2020-18Nov2020 | 19Nov2020 - 2Dec2020 |
| D2 | - | - | - | - | 8% |
| D3 | - | 8% | - | - | 10% |
| D4 | 10% | - | - | - | - |
Expected Output
| District | 24Sep2020-8Oct2020 | 9Oct2020-21Oct2020 | 22Oct2020-4Nov2020 | 5Nov2020-18Nov2020 | 19Nov2020 - 2Dec2020 |
| D2 | 40% | 60% | 70% | 80% | 8% |
| D3 | 25% | 8% | 30% | 20% | 10% |
Can someone please help me with the issue.
@sunny_talwar @nagarjuna_kotha @DeepakVadithala
Thanking in Advance.
Regards,
Jesh
