Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I would like to know the expression for summing over a distinct dimension.
A very simple example of my data looks like this:
Line | Date | Shift | Minutes |
---|---|---|---|
10 | 8/3/2017 | 3 | 480 |
20 | 8/3/2017 | 3 | 480 |
My complete data set has two years of dates and shifts in it across many lines. When the line is running, minutes is 480, otherwise it is 0.
I want to sum the minutes of a distinct shift. I have tried SUM(DISTINCT <ShiftNumber+Date> Minutes) but it doesn't work. I know that COUNT(DISTINCT ShiftNumber+Date) gives me the correct answer of 1.