qlik regardless any selection in pivot !

[Anonymous]

Hi,

as per the current diagram and set expression, only credit and debit value should change but Other values should be the same for all dates ( regardless of any selection).

I have tried the set expression like :

IF(lob='Credit',sum(value),
IF(lob='Debit',sum(value),
IF(lob='Other',sum({1<Date=>}value))))

but its not working as only 10/29/2018 having Other as lob all other dates dont have other as LOB.

when i should select any date other should display with constant date.

[Anil_Babu_Samineni]

May be ignoring the field in your set expression?

[tresesco]

Try to share a sample app to demonstrate your issue and expected output.