Transform format

[Kirsten]

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

[joaopaulo_delco · Accepted solution]

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.

[Kirsten]

@joaopaulo_delco  Sorry for the delay in response, had some free days. That works, thanks!

[Kirsten]

@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?

[joaopaulo_delco]

@Kirsten can you send a image of situation?

[Kirsten]

@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.