topic Re: Variables as Search Objects in QlikView

Variables as Search Objects

Mon, 28 Oct 2013 20:01:18 GMT

Is there a way to set the results of a Search Object or Current Selection window as a variable to reference in a pivot? I'm looking to limit a dimension to the variable entered by a user. It's somewhat complicated but we have leader data levels 1-10, and if the user enters the leaders name, we only want that one to appear in the pivot. I want to set one of the dimensions as that column (leader level). I'm thinking a variable/dimension limit would be the only way.

Re: Variables as Search Objects

israrkhan — Mon, 28 Oct 2013 20:14:15 GMT

Hi, two ways coming in mind, whether they are useful for you or not..

1) Change to Straight Table, and use the dimension limits Tab, and Show only =$(Variable)..

i assume you know how to create variable and input value, and use in dimension limits...if not

2) In Peviot Table properties, General tab, Use Calculation Condition, and can use expression like

=count(distinct [leader level])<=100, if he will select five [leader level], will see five in Pivot Table, 10 then 10 ans so on.

Re: Variables as Search Objects

Mon, 28 Oct 2013 20:25:15 GMT

Well the issue I'm having is designating the selection the user makes AS the variable. I can't figure out how to tell Qlikview that that object entry becomes the variable from the search object.

Re: Re: Variables as Search Objects

israrkhan — Tue, 29 Oct 2013 08:11:22 GMT

i did not get you properly,

but i think you are having problem in variable and inputbox, or slider, or so,

See the attached file, and example of how to use variable and inputbox, slider etc.

on second sheet you can see the pivot table , calculation condition, and on third sheet, see the slider, inputbox variable, used in straight table...

hope it helps

Re: Variables as Search Objects

Tue, 29 Oct 2013 13:09:17 GMT

I guess my real question is, can a dimension be a variable? Is there a way to tell a pivot table that one of the dimensions is based on a column selected via Search ?

Re: Variables as Search Objects

tresB — Tue, 29 Oct 2013 13:31:02 GMT

Dimension can be variable. Do you want the dimension itself (Say, Field1, Field2, ...) be variable or the dimension vaules (From Field1- Value1, Value2...)?

Re: Variables as Search Objects

Tue, 29 Oct 2013 13:34:46 GMT

I have 10 columns for level leaders (in my source data), and based on a VALUE (leader name) selected by the user I want the field name to change to that corresponding leader level. It would also be nice if the leader name can populate but its less important to me. Does that make sense?

Re: Re: Variables as Search Objects

tresB — Tue, 29 Oct 2013 16:25:40 GMT

Not yet very sure about your requirement. Guessing, may be like attached sample.

Re: Variables as Search Objects

Tue, 29 Oct 2013 18:58:09 GMT

Sadly, I cannot open this as I have the personal edition.

How about this:

Can one designate a user selection as a variable, then use that variable as a dimension?

Re: Variables as Search Objects

tresB — Tue, 29 Oct 2013 19:13:31 GMT

Ah! YES.

Does this help?