Limiting Field Values Scripting

[Anonymous]

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

[Oleg_Troyansky · Accepted solution]

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 an...

[maksim_senin]

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

[ramasaisaksoft]

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.