topic Limit dimension values using inline table in QlikView

Limit dimension values using inline table

surajap123 — Wed, 28 May 2014 13:46:31 GMT

Hi All,

I am actually hardcoding the dimension values in the expression in my straight table to show only specific values(Eg-salespersons)

Dimension: salesperson

Expression: =count({<salesperson={'*XYZ*','ABC*'}>}sales)

Instead, I want to create a inline table, so that power user can simply change the inline table eazily, whenever they want to change the salesperson to want to view.

I know how to create inline table, but not sure to which field i need to link this inline table.

Re: Limit dimension values using inline table

Anonymous — Wed, 28 May 2014 13:56:12 GMT

You can create a copy of the salesperson field as a data island:

Island:
LOAD DISTINCT salesperson as SP RESIDENT ...;

And, use this SP on the front end as a filter. Expression will be
=count({<salesperson=P(SP) >} sales)

Re: Limit dimension values using inline table

rwunderlich — Wed, 28 May 2014 13:57:47 GMT

Is this different then just having them select SalesPerson (and locking) from a listbox? f you didn't want the selection to affect other charts, you could put the listbox in an alternate state.

-Rob

Re: Limit dimension values using inline table

PradeepReddy — Wed, 28 May 2014 13:58:23 GMT

Hi Suraj,

If I understand the requirement in corecct manner, If the user selects the Salesperson from List Box, then its corresponding count should be evaluated.

Dimension : saleaperson

expression : count(Sales)

Re: Limit dimension values using inline table

surajap123 — Wed, 28 May 2014 14:06:05 GMT

Hi Michael,

Thanks!!

Your script is pulling the complete salespersons.

How can i hardcode the salesperson names in Island table? As i need only specific salespersons from Salesperson field.

Re: Limit dimension values using inline table

Anonymous — Wed, 28 May 2014 14:17:50 GMT

If you want only a subset of the salespersons - it depends. Do you have some rules, for example title of sales person? If yes, it could be:

Island:

LOAD DISTINCT salesperson as SP RESIDENT ...

WHERE match(Title, 'Director', 'Manager', 'Sales Person');

If you don't have rules but want to hardcode, you can use inline load:

Island:

LOAD * INLINE [

name1

name2

...

];

In this case make sure the names are correct, it is easy to misspell.

Re: Limit dimension values using inline table

surajap123 — Wed, 28 May 2014 14:54:58 GMT

Hi Michael,

Thanks a lot for your time..

Sorry to bother you again. I used both your scripts but getting syntax error..

I dont have any rules like title etc.

I just need specific salespersons from already exising table saleperson field in qlikview.

My script--

specificpersons:

LOAD DISTINCT salesperson as SP

RESIDENT qvtbl;

Island:

LOAD * INLINE [

name1

name2

from specificpersons;

I think the script is wrong somewhere. how can i create a inline table as the salespersons are coming from specificpersons table.

Re: Limit dimension values using inline table

Anonymous — Wed, 28 May 2014 15:17:22 GMT

There is no "from" for load inline. It is

Island:

LOAD * INLINE [

name1

name2

...

];

That is, you have to type each name exactly.

Re: Limit dimension values using inline table

surajap123 — Fri, 30 May 2014 14:01:36 GMT

Hi Michael,

Thanks a lot for your patience..you have been very helpful !!