topic Re: Expressions if FieldA = FieldB in QlikView

Expressions if FieldA = FieldB

Anonymous — Sat, 16 Nov 2024 05:11:01 GMT

Hi everyone

Is it possible to use an expression to match a field
For example
Count({<fieldA=FieldB>}value)

The reason I ask is that I want a count to reference the same dimension but the tables aren’t / can’t be joined without causing an issue with loops
I would like this formula to sit in the same table as others

Re: Expressions if FieldA = FieldB

lblumenfeld — Tue, 20 Nov 2018 23:09:25 GMT

The simplest way to do this is

Count( If(FieldA = FieldB, Value))

You can also use set analysis, but this works and is simpler.

Re: Expressions if FieldA = FieldB

Anonymous — Tue, 20 Nov 2018 23:45:26 GMT

Thanks for the quick reply - unfortunately I have some additional set analysis and it doesn’t seem to be compatible...
I just tried
Count(<{obj_type_code={‘CHB’,’BBF’},app_gc=P(app_gc1)>}DISTINCT(inv_no))

The app_gc has breakdown information in it and
The app_gc1 , obj_type_code and inv_no are in a separate table and have static product holdings
I can’t link them without losing info from the holdings

Re: Expressions if FieldA = FieldB

lblumenfeld — Wed, 21 Nov 2018 00:04:07 GMT

I'm still a bit unclear about what your data looks like. Is this part of the original question? If it is then you are able to mix set analysis with what I posted, so

Count(<{obj_type_code={‘CHB’,’BBF’},app_gc=P(app_gc1)> distinct If(FieldA = FieldB, inv_no ))

Is a valid statement. Is there data you can post to explain further?

Re: Expressions if FieldA = FieldB

Anonymous — Wed, 21 Nov 2018 09:03:02 GMT

I think you have done it thank you - I think the problem I have is that the volume of data I have is causing the program to give me the white screen of death !! 😂

I knocked up an example to share

Count({<obj_type_code={'CHB','BBF'}>}Distinct IF( gcn = gcn1, inv_code))

This has allowed to non linked tables with similar to sit within the same report
Note: I couldn’t link the tables due to filtering inconsistencies on the breakdowns table
Example =
Table1 is the Customer Holdings
Table 2 is the breakdowns

Simplified 👍