topic Re: Can I make combined selections from two fields? in QlikView

Can I make combined selections from two fields?

Anonymous — Thu, 14 Dec 2017 10:43:51 GMT

Hi there,

Please see attached QVW file.

As a user, I would like to be able to make a selection of two fields...

I have two different fields for "Region", one from invoice header and one from invoice line.

I would like to make a selection that includes all rows with a specific value from the two fields. Is that possible?

Thank you for advice!

Script follows (but see QVW for full details...)

InvoiceHead:

Load * Inline [

VoucherId, Head_CostCenterId

A, X

B, Z

C, Z

D, X

E, Y

];

InvoiceLine:

Load * Inline [

VoucherId, VoucherLineNo, Line_CostCenterId

A, 1, X

A, 2, X

B, 1, Z

C, 1, Z

D, 1, Z

D, 2, Z

D, 3, Y

E, 1, Y

];

CostCenter_Line:

Load * Inline [

Line_CostCenterId, Line_Region

X, North

Y, Mid

Z, South

];

CostCenter_Head:

Load * Inline [

Head_CostCenterId, Head_Region

X, North

Y, Mid

Z, South

];

Re: Can I make combined selections from two fields?

Anonymous — Thu, 14 Dec 2017 11:04:02 GMT

Are you going to any calculations after selection ?

Re: Can I make combined selections from two fields?

Anonymous — Thu, 14 Dec 2017 11:33:17 GMT

No, I just want to make a selection... It will be used for reducing data in QV Publisher.. For instance, I want to publish a document to a sales manager i region North, with all data from North (regardless head och line).

Re: Can I make combined selections from two fields?

swuehl — Thu, 14 Dec 2017 11:47:42 GMT

If you manage to bring both region fields into one resident table (like creating a single fact table by joining all your tables), you can follow

Canonical Date

and create a canonical region field you can make your selection in.

Re: Can I make combined selections from two fields?

Anil_Babu_Samineni — Thu, 14 Dec 2017 12:01:38 GMT

What is expected model?

Re: Can I make combined selections from two fields?

Anonymous — Thu, 14 Dec 2017 12:17:17 GMT

Thanks. I understand.

But as a user, it's not possible to make selections (filter data) over multiple fields like this?

In SQL you can just write an OR statement, which in this case would be:

SELECT

...

WHERE Head_Region='North' OR Line_Region='North'

Re: Can I make combined selections from two fields?

marcus_sommer — Thu, 14 Dec 2017 12:40:06 GMT

I have no experience to the publisher-reducing but maybe the following is as idea helpful:

- combining both region-fields like: Head_Region & '|' & Line_Region as Region

- where clause logic of: where wildmatch(Region, '*North*')

- Marcus

Re: Can I make combined selections from two fields?

swuehl — Thu, 14 Dec 2017 14:53:28 GMT

Thanks. I understand.

But as a user, it's not possible to make selections (filter data) over multiple fields like this?

Not easily.

You can use set analysis with a union of sets:

=Count({<Line_Region = {North}>+<Head_Region = {North}>} VoucherId & VoucherLineNo)

returns 5, like in your above sample.