Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Qliksense Flag on table

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.
Highlighted
Creator II
Creator II

Re: Qliksense Flag on table

HI Saumahasan Thanks for replying.

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

Re: Qliksense Flag on table

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

Re: Qliksense Flag on table

PFA the screenshot:

 

Highlighted
Specialist
Specialist

Re: Qliksense Flag on table

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.