Qliksense Flag on table

[New-Qlik]

Hello Everyone,

I have requirement to create two tables one showing all data and one showing data based on certain status value.

I have created second one based on a flag and bring that flag in table and it works fine. but if I click on table column status search bottom I can see all status even the one I have restricted via flag.

If I select those restricted columns then chart shows no data s per expectation.

My question is why it comes in table status column search . It should just show only flag condition one not all 

[saimahasan]

Hi Avneet,
Why dont you take a table and create a measure like =If(Flag=1,Status). This way you will be able to see only the required values under status column and since it would be a measure you wont get any search button on this column.

[New-Qlik]

HI Saumahasan Thanks for replying.

if i create a measure in table then it will not give me possiblity to search it from title.

[saimahasan]

So you can put the same condition under dimension and then you wont find the extra status appearing in the search box

[saimahasan]

PFA the screenshot:

[passionate]

Can you please rephrase your questions it's very confusing ?

what i understand is you want selection of status to be applied from the second table.

Queries:

1. why are you using "AND" condition in between status ? try achieving this flag in qlik script you can resolve your issue.

please post application for quick solution.