Limited Data on Different Sheet

[HMUTUAL01]

I have a data source with different values in a field (ie Gender M/F/U). I would like to have sheet 1 only reflect data where Gender is M, Sheet2 Gender is F.  How can I set it so the end user only see's M on Sheet1?

[maheshkuttappa]

Why don't you use set analysis to restrict your expression to show data based on gender for each chart?

Like  sheet 1 =  Sum({<Gender = {'M'}>} XXX) 

sheet 2 =  Sum({<Gender = {'F'}>} XXX) 

Or Use sheet-level action to Select in Field. 

I would use the former option rather than the latter.

[Vegar]

If you are using master measures like [User count] defined as count(Users) and have QlikCloud or a pretty new version of QlikSense then you can do this as well.

Sheet 1:

{<Gender = {'M'}>}[User count]

Sheet2:

{<Gender = {'F'}>}[User count] 

[HeshamKhja1]

There are multiple ways. Two methods are what the two previous comments mentioned.

I had a similar scenario and I used Sheet Actions to Select value in a field.

In you scenario, you can set an action Toggle Field Selection --> Gender = 'M' in sheet1 and Gender = 'M' in Sheet2.

[HeshamKhja1]

@HMUTUAL01 , were you able to solve it?

[HMUTUAL01]

It wasn't working for me so I created field in data loader.