Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have this data file
But I want to transform this in Qliksense to the format below. How to do that?
Quarter Market Sum(Numerator) Sum(Denominator) num/den
2020 Q4 NAM 1132 3421 0,33
2020 Q4 BNL 1132 3421 0,33
2020 Q3 NAM 1132 3421 0,33
2020 Q4 BNL 1132 3421 0,33
Hi @Kirsten !
To format the quarter you can use
=Year & ' Q'& Ceil(Period/3)
To format the other collumns you have to change the options formating your measures.
Hi @Kirsten !
To format the quarter you can use
=Year & ' Q'& Ceil(Period/3)
To format the other collumns you have to change the options formating your measures.
@joaopaulo_delco Sorry for the delay in response, had some free days. That works, thanks!
@joaopaulo_delco Though I am currently checking my data. My original datafile contains 1545 records. And when I create a new table in QlikSense and export the data I get 482 records. I would assume they would classify each month as a quarter? What goes wrong?
@Kirsten can you send a image of situation?
@joaopaulo_delco yes I have some screenshots. What type of information do you need, in a screenshot? From the screenshot below, when I compare that to my original datafile, I am just missing a large part of the records.