Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

Qliksense Flag on table

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 

Capture.PNG

5 Replies
saimahasan
Partner - Creator III
Partner - Creator III

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
Creator II
Creator II
Author

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
Partner - Creator III
Partner - Creator III

So you can put the same condition under dimension and then you wont find the extra status appearing in the search box
saimahasan
Partner - Creator III
Partner - Creator III

PFA the screenshot:

 

passionate
Specialist
Specialist

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.