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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a sheet looking like this:
Region | People| Number
JAPAN Boy 10
JAPAN Girl 20
JAPAN Total 30
Is it possible to create a new column when loading the sheet to make the result look like this:
Region | People| Number| Total_Number
JAPAN Boy 10 30
JAPAN Girl 20 30
I was thinking something like : IF([People], 'Total') AS [Total Number], but it didn't work.
You can try this.
LOAD * INLINE [
Region, People, Number
JAPAN, Boy, 10
JAPAN, Girl, 20
JAPAN, Total, 30
Where People <> 'Total';
Number as Total_Number
Where People = 'Total';
Drop Table Data_Temp_1;
View solution in original post
If this new column is an aggregation I suggest creating expression in dashboard.
To tell you the truth... I don't really fully understand the issue at hand.... If you can give another example🤔
Made it. Not with the exact syntax but with the same logic.
Thanks bunch! 🌻