Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Compare the values of different rows for particular dimension and show the status

Capture.PNG

So in this image you can see there are two practitioner_id. And the both Practitioner_id are having common Manufacturer and Drug name and the third column is showing matched with which practitioner. So here we can see the third column is published with Matched and 56834216, the practitioner id with which it is matching.

So in third column i want show that both the practitioner's are having matching Manufacturer and drug name.

Can it be possible?

5 Replies
Highlighted
Esteemed Contributor II

Re: Compare the values of different rows for particular dimension and show the status

try with Autonumber(Manufacturer&Drug)  this will create a unique number for each manufacturer

in load script create a key as


PractitionerID,

Manufacturer,

Drug,

PractitionerID&'_'& Autonumber(Manufacturer&Drug)  as Common

Highlighted
Valued Contributor

Re: Compare the values of different rows for particular dimension and show the status

Pls see this, may be this is what you are looking for.

Highlighted
New Contributor

Re: Compare the values of different rows for particular dimension and show the status

Its is working. But not as I want. See the image below:

Capture1.PNG

So here result is matching with all the practitioner in the application. But what I want is, it should match with Practitioner current selected set of Practitioner's which are there in this chart.

I am having a question that, can we calculate this Result field in the chart only.

Is there any way for doing that?

Highlighted
Esteemed Contributor II

Re: Compare the values of different rows for particular dimension and show the status

You cannot have a Result field like this because you may have n number of Manufacturer and Drug name repeat for multiple practioners. Which is why i suggested to only keep the Key column which you can select on

can you post some sample(dummy) data

Highlighted
Valued Contributor

Re: Compare the values of different rows for particular dimension and show the status

At the chart level..