So first off, Super new to Qlik. I am using Qlik Sense. My experience is 10 years front end OBIEE Developer with some back end design work. I am ok with SQL (I get the job done) especially on the front end. Currently, I have access to the data load editor in Qlik, but I really need to do this "binning" on the front end.
So here is my ask/brick wall.
I have a huge list of IDs that have made transactions and in one view I want to group those views by volume. So (imagine bar chart) you would see the number of IDs that made 1, 2, 3, 4, or >4 transactions for the selected period of time. My support person usggested I use a Value List in Qlik Sense. What built was simple:
=ValueList('1', '2', '3', '4', '>4')
I then referenced the value list in a metric count.
What I am basically trying to do is the following:
IF(ValueList('1', '2', '3', '4', '>4')='1'.
Bring back the Count of all IDs that have Interactions =1 where that field that drives # of Interactions looks like this