Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Help with using dimension value in set analysis

Hi,

I have a model similar to the one attached. I'm looking for an expression for the IN column to count for the reversed route (OUT is C1 to C2, In would be C2 to C1)

Thanks!

1 Reply
Frank_Hartmann
Honored Contributor II

Re: Help with using dimension value in set analysis

Maybe like this:

OUT:
if(right(Shipper,1)<right(Consignee,1),count(Id))

IN:
if(right(Shipper,1)>right(Consignee,1),count(Id))