Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.
have you tried something like below?
count({<ProgramName={'A'},Event={'1,2'}>}RecordID)
OR
count({< RecordID = p({<ProgramName={'A'},Event={'1,2'}> } RecordID) >} RecordID)