Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As per customer requirement, we have to calculate Retention Rate, the logic of calculating Retention rate is the number of unique seller who does sale in Month of December the number of unique seller is recruited in Month of November.
When we apply following expression in Table and KPI, it will give the expected result but when we apply same expression in Pivot Table, it will not give the expected result.
Expression we used to get that expected result : sum({<Month=>}[TL_Seller Id]))
Below screenshot is for your reference.
Hi @ga18906 , Kindly refer to community post for an alternative solution -> https://community.qlik.com/t5/QlikView-App-Dev/set-analysis-not-working-on-pivot-table/td-p/776397