How to find the common field name for two selection?

[mohan_1105]

Hello Qliker,

I am trying to display the common drug used in two different type of treatment in the bar chart having a measure how many physician prescribed the drug.

I know it can be achieved by p() function. I gonna use this function for the first time and I'm not getting it correct.

I have field Treatment category and Drug prescribed when the user what to know the drugs prescribed in common based on the treatment category selection user has made in filter pane.

Thanks and regards,

Mohan

[MK_QSL]

Hi, not clear from your description.. Can you provide exactly what you are looking for in the expression?

[mohan_1105]

Hi,

Like,

Count(distinct {<[Treatment Catergory]=p({"GetFieldSelections([Treatment Category])"})>}Physician_ID)

[mohan_1105]

Hi Manish,

I guess you could understand what I'm looking for from the expression I just replied. Kindly let me know in case it requires more explanation.

Regards,

Mohan

[MK_QSL]

Simply try this and let me know

Count({<[Treatment Catergory] = P([Treatment Catergory])>}Distinct Physician_ID)