Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set of NL codes, Group, EoM and value.
I would like to split this into working days for each of the NL codes and NL & Group so I can calculate a YTD for each of them.
this is held on a Excel Sheet which I bring into Qlik any help would be fantastic.
Acc # | Dept | Month | Value | cc |
1000 | 10 | 31/01/2023 | 10,307.00 | 01 |
@RichardLee Could you please provide the sample data and expected output?