How to freeze the value in the straight table in Qliksense?

[Nidhi2]

Hi All,

Please help me on this below request

When the selection is made on a filter the value associated to that filter should be displayed with values and also remaining  values should be displayed as zero in it ,no matter which filter is selected.

Thanks

[justISO]

Hi, for example, if you have 2 dimensions and 1 measure in your table, change your measure expression to this approach:

Sum({1} aggr(value, dim1,dim2))

You need to list all dimensions into expression and adjust this to your case accordingly.