Help in P() Function.

Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have below issues in chart..

Consider two fact tables Call Detail and Event Attendee

call detail
call detail id	call name	call status	medical event id	Table_Name
10001	c_01	Planned	M01	Call Detail
10003	c_02	Submitted	M02	Call Detail
10005	c_03	Cancelled	M03	Call Detail
10007	c_05	Planned	M07	Call Detail

Event attendee
Event attendee id	medical event id	Attendee name	Attendee Status	Table_Name
E01	M01	aaa	Attended	Event attendee
E02	M05	ddd	Invited	Event attendee
E03	M06	ccc	Accepted	Event attendee
E05	M02	bbb	Accepted	Event attendee

both the fact table having Key Link fields

for Call detail: AutoNumberHash128([Call Detail ID]&'Call Detail') as [%KeyLinkField]

for Event Attendee: AutoNumberHash128([Event Attendee ID]&'Event Attendee') as [%KeyLinkField]

but we don't have any linkage between Call detail table and Event attendee table. we don't have event attendee id in call detail table we have only medical event id .And we cant join two fact tables.

I have used below expression to my chart

count({<[Medical Event ID]= P({<Table_Name= {'Event Attendee'}>}[Medical Event ID]),Table_Name= {'Call Detail'}>}1

)

But When i select call status filter the chart is going blank which i used above expression in Chart,I want to display the chart even call related filters are selected.

Possible values to be captured medical event id for these calls from event attendee table

Please help me what modification should i change in above expression?

topic Help in P() Function. in QlikView

Help in P() Function.