Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
msawyercke
Contributor

Help Request for Chart

Hi,

I'm building various tables with  various store location attributes.  I'm now wanting to create a table that shows our unique store identifier ('PS #'), but ONLY for those stores that are scheduled for remodel.

So, in the Data Load editor, I created the following Flag:

IF ("Required?"='YES', 1, 0) as Remodel_Flag

The data loads fine, and I see the new 'Remodel_Flag' variable in my list of options, but where do I use this flag in the table so that just those PS#'s ('Remodel_Flag = 1') appear in the table?

Thanks for your help!

1 Solution

Accepted Solutions

Re: Help Request for Chart

Make sure this is unchecked -> Show Null Values

Capture.PNG

9 Replies

Re: Help Request for Chart

1May be use it in your expressions if you wish to restrict your table to view only those rows where Remodel_Flag = 1

{<Remodel_Flag = {1}>}

msawyercke
Contributor

Re: Help Request for Chart

HI Sunny, Hope you are having a good day.

This expression has an error:

[PS #]{<Remodel_Flag = {1}>}

Re: Help Request for Chart

May be try this:

Only({<Remodel_Flag = {1}>} [PS #])

msawyercke
Contributor

Re: Help Request for Chart

Sunny, I get an 'invalid dimension' messageCapture.JPG:

Re: Help Request for Chart

I thought you were using it as an expression, try this:

If(Remodel_Flag = 1, [#PS])

msawyercke
Contributor

Re: Help Request for Chart

It is suppressing the PS # field for records where Remodel_Flag = 0, but all the records are showing in the chart (whether Remodel_Flag = 0 or 1).

Capture.JPG

Thank You, Sunny...

Re: Help Request for Chart

Make sure this is unchecked -> Show Null Values

Capture.PNG

msawyercke
Contributor

Re: Help Request for Chart

Thanks, Sunny - I can't even begin to tell you how much I've appreciated all your help...

Have a great day...

Re: Help Request for Chart

No problem Mike

I am glad I have been able to help you out with most of your queries.

Best,

Sunny