Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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.