topic Re: Rename a value in dimension and load only that value in QlikView

Rename a value in dimension and load only that value

davyqliks — Sat, 16 Nov 2024 17:34:50 GMT

Hi,

From a dimension in the load i am trying to rename some values as another and then only load the renamed.

See the below effort.

if(Len(Trim([Fibres])) > 0 and wildmatch(trim([Fibres]),
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
)
, Only('OtherMaterials'),
[Fibres]) as OtherMaterials,

I am trying to find these values:

'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'

and then name as 'OtherMaterials' and then only load those values as the dimension [OtherMaterials]

I can confirm all is working other than ONLY loading the renamed as OtherMaterials.

Can anyone assist please?

Thank you in advance.

Re: Rename a value in dimension and load only that value

davyqliks — Mon, 25 Jan 2021 13:01:47 GMT

@PriyankaShivhare you helped with part of this code, are you able to assist if possible please?

Thank you in advance.

Daniel

Re: Rename a value in dimension and load only that value

PriyankaShivhare — Mon, 25 Jan 2021 15:33:23 GMT

if(Len(Trim([Fibres])) > 0 and wildmatch(trim([Fibres]),
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
)
, 'OtherMaterials'
[Fibres]) as OtherMaterials,

Hope this helps!

Thanks

Priyanka

Re: Rename a value in dimension and load only that value

davyqliks — Tue, 26 Jan 2021 09:00:00 GMT

Thanks Priyanka,

I tried this but it was not working then realised some other values were pulling from another table.

Thanks again so much for your help.

Daniel