Restrict data in Qliksense sheets for a specific field value

[richard24best]

Hi Team,

I have a requirement where i am trying to create different sheets LIVE and SETTLED.

But i want to show LIVE sheet with only field values SETTLEDFLAG = ' N' and SETTLED sheet with only filed values SETTLED = 'Y'.

I did try to add via sheet properties (actions) - select values in a field = 'N' for LIVE Sheet and similary 'Y' for SETTLED.

The issue i am facing is when i give a button with hyperlink to switch between sheets, the field values are being overwritten as per new sheet. Is it possible to restrict the field values in the respective sheets?

Regards,

Richard

[Vegar]

You could add a set modifier to the measures in each sheet.

If you today are using Sum(Value) then you can för your SETTLED sheet change it to Sum( {<SETTLED={'Y'}>} Value)