topic Re: Qliksense Flag on table in App Development

Qliksense Flag on table

New-Qlik — Tue, 02 Apr 2019 20:29:33 GMT

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

Re: Qliksense Flag on table

saimahasan — Wed, 03 Apr 2019 06:33:53 GMT

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.

Re: Qliksense Flag on table

New-Qlik — Wed, 03 Apr 2019 06:42:39 GMT

HI Saumahasan Thanks for replying.

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

Re: Qliksense Flag on table

saimahasan — Wed, 03 Apr 2019 06:44:11 GMT

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

Re: Qliksense Flag on table

saimahasan — Wed, 03 Apr 2019 06:46:03 GMT

PFA the screenshot:

Re: Qliksense Flag on table

passionate — Wed, 03 Apr 2019 07:01:26 GMT

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.