topic Re: Limiting Field Values Scripting in QlikView

Limiting Field Values Scripting

Anonymous — Mon, 19 Oct 2015 22:27:27 GMT

I have the following fields and data:

TimeDispensed Retail Pharmacy

8:10:10 Plaza

8:20:11 CVS

8:30.11 Walgreens

8:35:05 Plaza

What expression can i use to restrict TimeDispensed displayed in a straight table to display only values of a particular Retail Pharmacy, say Plaza?

Thanks you

Re: Limiting Field Values Scripting

Oleg_Troyansky — Mon, 19 Oct 2015 22:58:02 GMT

You can use Set Analysis, something like this:

only({<Pharmacy={'Plaza'}>} Time)

Check out my new book QlikView Your Business. In the book, I'm teaching various uses of Set Analysis, from the very basic ones to the most complex analytic solutions.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Limiting Field Values Scripting

maksim_senin — Mon, 19 Oct 2015 23:01:05 GMT

Hi Christopher,

If you really use a chart with type "Straight Table" not a Table box object, then you have two options (depending on what your dimensions will be):

1. Add a calculated dimension with will restrict set of "Retail Pharmacy" values, usually this is done vie Aggr() function

2. Add a set anaylsis to your expression, something like this - {<[Retail Pharmacy]={"Plaza"}>}

It would be helpfull if you provide a qvw sample file.

Best regards,

Maxim

Re: Limiting Field Values Scripting

ramasaisaksoft — Tue, 20 Oct 2015 05:25:10 GMT

Hi Chitemerere,

Load * TimeDispensed ,

Retail Pharmacy

from c\......

where [Retail Pharmacy]='xyz..'

I hope u want to restrict this data in Script so that it is good else fallow above 2 options.