topic Re: Help with Formula (Distinct) QlikSense is Hiding Data in App Development

Help with Formula (Distinct) QlikSense is Hiding Data

kgordis — Sat, 27 Apr 2024 00:55:31 GMT

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

Re: Help with Formula (Distinct) QlikSense is Hiding Data

rubenmarin — Sat, 27 Apr 2024 06:21:51 GMT

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.

Re: Help with Formula (Distinct) QlikSense is Hiding Data

kgordis — Sat, 27 Apr 2024 20:29:05 GMT

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.

Re: Help with Formula (Distinct) QlikSense is Hiding Data

vinieme12 — Mon, 29 Apr 2024 06:29:50 GMT

have you tried something like below?

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

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