topic Selecting Specific Data in QlikView

Selecting Specific Data

Sat, 20 Nov 2010 09:37:08 GMT

Morning from SA

I want to know if it is possible to do a global selection for a specific sheet. Currently I do it for each expression. This is tedious and repettative.

I tried doing it under the General tab in the calculation condition but this does not seem to work.

Any other Ideas!

Thanks

Selecting Specific Data

Anonymous — Sat, 20 Nov 2010 15:43:10 GMT

Could you please clarify what you mean?
The selections by default are always "global", not even for a sheet, but for the overall data, no matter what the sheet is - unless you do "tedious and repettative" work to avoid the normal Qlikview behavior.
My guess that you maybe want a default selection when you go to a specific sheet. If this is true, you can do it using Actions on the "OnActivateSheet" event, see Triggers in Sheet Properties. Is it what you need?
If not, an example would be helpful.

Selecting Specific Data

Sun, 21 Nov 2010 06:29:01 GMT

Morning Michael

Thanks for your response I will try and explain and give the example John Houston helped me with.

Our data coming into QV contains various transaction types allocated to the various production cycle and QV gives us an excellent way to view the data.

If we view each type on its own it works like a dream but as soon as I want to join 3 transaction types it becomes a burden.

Example:

1. We want to view the exact same information for transaction type "REC" "SOR" and "MAR" (Three Objects in a sheet)

2. We want to see Sum(Units), Sum(Mass), AGG(Mass), Sum(Value) ETC

3. John helped me and in the definition of each expression I included EG. Sum({$ <Transaction={REG}>} Mass) / Count({$ <Transaction={REG}>} Tag) - {$ <Transaction={REG}>} is repeated in each expression and for each Sheet object.

4. What I would like to do is complete one sheet, clone it and change one global selection (Whatever) to make it work for the other transactions.

I tried various things but can not make it work.

We are using QV for 3 weeks now and am still very unsure of all the terminology and methods of doing things.

Thank you very much for your support.

Regards Albert

Selecting Specific Data

Anonymous — Sun, 21 Nov 2010 20:07:09 GMT

Hi Albert,
I cannot say it gets much clearer... Let me assume that you want to view objects on a sheet for only one transaction type at a time. If this is correct, you need only one sheet, and much simpler expressions like:
Sum(Mass), Count(Tag), etc....
(I have to tell that this part in your example is not clear to me, probably something is missing: - {$ <Transaction={REG}>})
No any set analysis needed in expressions - the selection does it instead. Next, use a list box of transactions types as a filter, and allow "only one value selected". So, you select REG or SOR, or MAR - and see the objects for the currently selected transaction type. This is the normal Qlikview behavior. No need for separate sheets per transaction type.

If my assumptions is not correst, please tell me what I got wrong.

Selecting Specific Data

Sun, 21 Nov 2010 21:08:23 GMT

Hi Michael

I will try again.

I do use list boxes to make the task simple and it works properly.

We are working with cattle and want to measure and compare the different performance scenarios during its growth phases. A total of 6 Performance levels. Each one of these performance levels have a between 6 or 8 measuring criteria. I now have to code between 36 and 48 individual expressions to get what I want.

If I could have coded {$ <Transaction={REG}>} as an object fixed variable it would have made the task much simpler.

I will keep on looking as I do believe that QV will be able to do the job, I just do not know where to look for the solutuion.

Thanks Albert

Selecting Specific Data

Anonymous — Mon, 22 Nov 2010 02:03:40 GMT

Hi Albert,
You certainly can create a variable (let's call it vTrans) like this:
='{$<Transaction={' & Transaction & '}>}'
And, depending on the selected value of Transaction, the string vTrans will be
{$ <Transaction={REG}>}
or
{$ <Transaction={SOR}>}
...
And you can use it as part of expressions.
(I'm still not pretending to understand what you need, but hope it will give at least something. Not sure why it is simpler in your case than a straightforward selection...)

Selecting Specific Data

Mon, 22 Nov 2010 03:20:40 GMT

Thanks Micheal

Will try your solution and let you know.

Thanks for all your effort.

Albert