Help with Formula (Distinct) QlikSense is Hiding Data

[kgordis]

Hello, 

I am panicking.

Changed data model and impacting my tables now. Now I have multiple rows of data with the same ProgramName with multiple Events and QlikSense is hiding data in the table. Just Added RecordID

I want to see NA and ProgramName A, Events 1 and 2.
Qliksense is Program A, but the Event Field is blank, but there is data there. 
Assume somehow I have to include Distinct events. Any recommendations?

Currently using:
IF(Region = 'NA' and ProgramName = 'A', [ProgramName],Null())

RecordID	Region	ProgramName	Event
1	NA	A	1
2	NA	A	2
3	NA	B	1
4	EU	C	1

[rubenmarin]

Hi, I will need more info to know what's happening.

How RecordID is created?

When you post 'Currently using'... using where? to load a fields? as a condition?

Is Event in the same table as ProgramName? are merged using a join? a relationship in the data model?

Maybe it will be better to post all the affected script (only wth the impacted fields) to know what are you trying to do.

[kgordis]

I was trying to prefilter the data using a formula and avoid the user having to use a filter so I could build stories.

Figured out a solution. 

Amended ProgramName to 

ProgramName + Event to create unique names for each row.

When I changed to column data QlikSense is now showing what I want. Must be issue with how QlikSense simply operates.

Program A - 1
Program A - 2

Think I am all set now. 

[vinieme12]

have you tried something like below?

count({<ProgramName={'A'},Event={'1,2'}>}RecordID)

OR

count({< RecordID = p({<ProgramName={'A'},Event={'1,2'}> } RecordID)  >} RecordID)