Good evening everyone, i am new of Qlikview and I apologizein advancefor my poor English. Now my problem!
I have a dimension called DescAsaBreve that contains a series of name/text values (ex. x, y, z, u). I would like to create a new value calculated, always in the same dimension DescAsaBreve, i called k, made by the union of two fields (ex. x and y) and then I will sum the relative sales value. I have touse the scriptwith for example concat funciont ora new variable or what? How can I do? Thanks in advance
Thank you very much for your reply .. actually now I just need to create this new dimension k and no set formulas in the script, which are already provided in the tables in the document.
I created a new dimension using the script given below, but the formulas in the document are reset as if did not read the new dimension created (but I see in the list box the new dimension created. Where am I wrong?
Concatenated (Date) load '99 - AFH 'as DescASABreve Resident Date where Match (DescASABreve, '01 - AFH ', '20 - AFH Old', '01 - AFH New ');