I'm new to QlikSense and struggling with a issue related to distinct records and/or FirstSortedValue. Unfortunately, other posted solutions have not resolved my problem.
I have a data set with customer interaction data, which includes multiple records for customers. This information is organized with a PivotTable by interaction month, customer type, customer location and other related dimensions.
I would like the ability to show only a unique customer record for the month of the first interaction. Ideally, I could apply this logic to both my PivotTable and other visualizations on the page.
Although I tried applying the 'FirstSortedValue' formula in my PivotTable, it returned the date, customer# or number of the first interaction as the 'value'. Given that I'm organizing by date, I want to return a single count for a given customer, for month of the first interaction (not the date as the value). This will allow me to display how many first customer interactions occurred in each month.
If QlikSense doesn't allow this with the 'Measure' expression within a PivotTable, is there a way to apply as a filter for the entire page, enabling me to only show the first interaction for all tables/visualizations?
I would appreciate any help that you can provide. Thank you
