Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Use variables as filters for showing values in a table

Hi,

I need to perform the following operation:

  • I have a table (excel file) with two fields (ID and Text) containing a series of texts/messages
  • My QV calculates a number of variables (var1, var2, etc) through some sliders; each of the variable ir related to one of the ID in the excel
  • the values of the variables are used to determine whether the text need to appear (if a certain condition is met, i.e. var1>0, then ID1 is shown) or not, in which case the corresponding rows of the excel file are not shown
  • each row in the excel file requires different conditions to determine wether it needs to appear or not

Can this be performed? If so, how?

Caveat: after I load the data the first time, I cannot reload the data again.

I'm thinking about a straight table where an expression based on a series of nested if() creates a flag for each of the ID, however as the list of ID grows (20-50-100) the nesting becomes impractical.

Thanks in advance for your help.

Pat

2 Replies
MVP & Luminary
MVP & Luminary

Re: Use variables as filters for showing values in a table

Hi,

PFA file for solution.  Hope it helps you.

Regards,

Jagan.

Not applicable

Re: Use variables as filters for showing values in a table

Hi Jagan

the inline and findvalue definitely help but only solve half of the issue.

As of now, the tool is able to select 1 of the set of n options in the table and list it in the straight table.

What I need to do is:

  1. have an additional  set of m options in the table
  2. have a different variable able to select 1 within this set of m options
  3. the selected option needs to be displayed in the same straight table along with the option selected among the set of n available

Step 1 and 2 seem just a duplicate of what you did. I'm not sure how to include the 3rd in the expression in the straight table.

Thanks

Pat

Community Browser