This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello got a fact table in which I have the fiscal year and period; the fiscal year starts on Aprilso in a row of data I might have the following rows with the respective year and period values
2021 12021 22021 3....I want to translate these into 2021 April2021 May2021 June...kindly advise
You can try like:
View solution in original post
You can use Mapping & ApplyMap for this or pick & match function like
Pick(Match(Month, 1,2,3,4,5,6,7,8,9,10,11,12), 'Apr', 'May', 'Jun', 'Jul', 'Aug','Sep','Oct','Nov', 'Dec', 'Jan', 'Feb', 'Mar')
isn't there any function to do it other than the mapping table?the thing is that I don't want to modify the script so thought there would be any function and use in the chart
You can try with Pick & Match function as mentioned in the earlier post