topic Is it possible to select in multiple fields by .Select or .ToggleSelect? in QlikView

Is it possible to select in multiple fields by .Select or .ToggleSelect?

Anonymous — Wed, 20 Apr 2011 04:13:19 GMT

Fox example,

LOAD * INLINE [
Institution, Distributor,Sales
A101,B101,500
A102,B101,600
B101,C102,350
B101,D103,200
A103,C102,600
];

I want to split the QVW file, which keep the Institution='B101' or Distributor='B101'.

How can I do it by Macro?

Is it possible to select in multiple fields by .Select or .ToggleSelect?

rwunderlich — Wed, 20 Apr 2011 05:40:49 GMT

You can issue multiple Selects. First one one field and then the other. But why use a macro?

Is it possible to select in multiple fields by .Select or .ToggleSelect?

Anonymous — Wed, 20 Apr 2011 06:59:35 GMT

I want to auto-split the QVW file by Macro.

For example,

B101.qvw => Institution=B101 or Distributor=B101

B102.qvw => Institution=B102 or Distributor=B102

Is it possible to select in multiple fields by .Select or .ToggleSelect?

Wed, 20 Apr 2011 08:24:11 GMT

John,

Please have a look at attached sample qvw.

That may help you to achieve whatever u want.

Is it possible to select in multiple fields by .Select or .ToggleSelect?

rwunderlich — Wed, 20 Apr 2011 08:52:01 GMT

Here are a number of non-macro solutions, depending on your business problem.

1. One qvw, use SECTION ACCESS or Publisher to reduce the data to the content appropriate for the user.

2. Multiple QVWs, limiting the the data with WHERE clauses.

3. One qvw data that contains the all data model. BINARY LOAD this model in multiple qvws and use INNER JOIN to reduce the data to the applicable set.

Hope this helps.

Is it possible to select in multiple fields by .Select or .ToggleSelect?

Anonymous — Thu, 21 Apr 2011 04:34:51 GMT

Dear Rob,

My purpose is to auto-split(reduce) the QVW by all the customers' id, like A101,A102,A103,...
Actually, customersid in two columns, Institution and Distributor.

for example,
B101.qvw will contains

[ A101,B101,500
A102,B101,600
B101,C102,350
B101,D103,200 ]

C102.qvw will contains

[ B101,C102,350
A103,C102,600 ]

Some different QVW file maybe contain same rows of all.

1. One qvw, use SECTION ACCESS or Publisher to reduce the data to the content appropriate for the user.
A:If using SECTION ACCESS, I think it is hard to achieve it.

2. Multiple QVWs, limiting the the data with WHERE clauses.
A:If using WHERE in QVW script, it is impossible to shrink the QVW size, and reload data for every splited QVW(like B101.qvw,...) again.

3. One qvw data that contains the all data model. BINARY LOAD this model in multiple qvws and use INNER JOIN to reduce the data to the applicable set.
A:Both 1 and 2.