Conditional Total in Qliksense

[ferha_jafri]

Hello Experts,

In Qliksense in straight table I am looking for conditional Total, i.e. I want to have 2 expressions one show rows total on the basis of condition and the other do not show total on the basis of condition. PFA with the view that I have in Qlikview and I want to replicate in qliksense.

[Dalton_Ruer]

You can use the "Show column if" expression for each column to determine if it should be shown or not in the same way you use QlikView.

[ferha_jafri]

That I tried , but here the problem is that if we enable Total in appearance the Total will come irrespective of the condition applied on the column. Although in Qlikview that is not the case , there the Total row will appear and hide on the basis of the conditional column.