topic Re: Filter Data by using a variable in App Development

Filter Data by using a variable

Sat, 27 Feb 2016 06:55:59 GMT

(QLIK SENSE)

Hallo to all,

again there is a (hopefully easy) Problem I'm concerning of. I want to filter my data by using a variable. I've already read some threads about such a topic but can't adapt it to my problem, because i don't understand the way to use of $<xyz=...> which is often mentioned.

My Problem:

I have some Sheets. On one Sheet i have 5 buttons. Each button set the value of variable x to a different value for example 2012, 2013, ... . If i press one of these buttons, i will only get those data for example of the year 2013 (if i press Button 3). So i want to see only the customers who bough something in year 2013 in table 1. Or the orders made in 2013. I think you know what i mean. Is this possible?

Is it also possible to combine 2 buttons. If i use for example toggle buttons and different variables for each button, can i Filter customers, orders and the other data by 2 years so i get all data of e.g. 2012 and 2013 if these buttons are active?!

I hope you understand what i mean and that you know a way to realize it. Thanks a lot

Michael

Re: Filter Data by using a variable

Tue, 01 Mar 2016 09:16:22 GMT

Can you give me an example or QVF ??

Re: Filter Data by using a variable

Tue, 01 Mar 2016 11:29:14 GMT

One Simple Example:

I have a table with the dimensions PersonID, PersonName & Age and i've got a button. If i press the button, i'd like to select the PersonID "12345". I know that i could pick 12345 from the Column PersonID of the Table in this example, but i need a formular or another way, to solve the problem of my first post. If there is a way, to say Qlik Sense: ok, pls select the PersonID 12345, i need the syntax to do so, because this way i can solve future problems by just changing column names or so on

Thank you very much.

Re: Filter Data by using a variable

Tue, 01 Mar 2016 11:53:56 GMT

The Set Analysis syntax would be something like:

SUM({$<

[PurchaseYear] = {'$(=vYearVariable)'}

>} [FieldToSum])

Re: Filter Data by using a variable

Tue, 01 Mar 2016 11:55:12 GMT

Check out:

Set Analysis: syntaxes, examples

Re: Filter Data by using a variable

Tue, 01 Mar 2016 11:57:44 GMT

But this way, I have to aggregate a measure. But I only want to select one or more values for a Dimension.

Re: Filter Data by using a variable

Tue, 01 Mar 2016 13:56:18 GMT

Not exactly clear on what you need, but from my understanding of what you want, you could try an IF statement for your dimension:

IF([FieldToFilter] = vFilterVariable,[FieldToFilter])

then untick the "Show Nulls" in the dimension property.

Re: Filter Data by using a variable

Tue, 01 Mar 2016 15:33:33 GMT

First of all: I'm very glad, that you try to help me, but unfortunately it's still not the solution

Next try:

I create a table inline:

table1:

load * inline [

id,name,age1

1,robert,23

2,maxi,44

3,peter,12

4,bella,56

5,hans,44

6,robert,12

7, hans,33

];

then put a table-extension on one sheet and set id, name and age as dimensions.

If i click e.g. on "robert", qlik sense filters the data ad-hoc, so that i can see only the lines

1,robert,23

6,robert,12

and the current selection on the grey filterbar over the white sheet "name: robert",

What I like to do is:

Instead of click on the item "robert", I want to click on a button (or even another object) and the current selection will be set to "name: robert". Is it possible to set a selection to that special one with a formular, where I can say: show me all data connected to that value --> This means, that the selection will be name=robert? If so, i could change "robert" to "hans", and the next time i click the button or another object, qlik sense will show all data which are connected to the name "hans" so in the grey filterbar appears the filter name : hans.

Of course, if i would have more data like adress, job title, and maybe some measures, they will also get filtered by that term, because Qlik Sense seems to set a "where clause" in the background, so there will be no data set for person "bella" shown.

Hope this was helpful!

Re: Filter Data by using a variable

alextimofeyev — Wed, 02 Mar 2016 10:15:22 GMT

I don't think it is possible to do what you are asking for at the moment. I was looking for this kind of thing not so long ago, and the closest solution that I found was the Slider extension. By the way, did you know that there are lots of free extensions for QS at branch.qlik.com?

We may write an extension that does it some day, or maybe somebody else will.

Re: Filter Data by using a variable

Wed, 02 Mar 2016 11:32:17 GMT

Perhaps an extension?

Qlik Branch

This one will let you set a filter by clicking a button.

Re: Filter Data by using a variable

Wed, 02 Mar 2016 11:46:16 GMT

I already got this extension 😉

I choose the item "select in field" because that's exactly what i like to do.

I choose field "name" and as value "robert" but it doesn't work 😞 Did you try it on your own? Maybe I did just a stupid mistake using this function?!

Re: Filter Data by using a variable

Wed, 02 Mar 2016 15:17:45 GMT

try without the quotation marks

Re: Filter Data by using a variable

Wed, 02 Mar 2016 19:37:53 GMT

Hello to all of you,

finally everything works fine 🙂

1. I recognized, that there is a new version of that extension. 😉

2. You can set the value to more than one item by using this syntax: (Robert|Hans).

Thanks to all of you trying to help me!!!

Re: Filter Data by using a variable

alextimofeyev — Thu, 03 Mar 2016 08:53:59 GMT

Thank you, Andrew!

I was searching for "button" and this extension didn't come up in the results.

Re: Filter Data by using a variable

Tue, 13 Dec 2016 14:02:33 GMT

Did this solution work for you? I can't figure out how to use that

Re: Filter Data by using a variable

abhi1693r — Thu, 27 Jun 2019 13:48:47 GMT

Hi,

I was looking at a similar problem and wanted to know if a solution was possible.

I have a field with values 1, 2 and 3. When a user selects 2, I want 1 to be auto selected. Similarly, If a user selects 3, I want 1 and 2 to be auto selected.

Can you help?