Qlik Community

Qlik Sense App Development

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

avneet85
Contributor

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
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.
avneet85
Contributor

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.
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
Partner
Partner

Re: Qliksense Flag on table

PFA the screenshot:

 

passionate
Valued Contributor

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.