topic Re: Set Expression for Calculated Dimension in QlikView

Set Expression for Calculated Dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to have a detached table, but the server option does not support it. I think the workaround is to use set expression. But so far, I have not been able to make it work. Here's my requirement. I need to extract a portion of string from a field named "ItemDescription" and when LinkedAccountId is 123. Below is the original expression. But I need it to be "detached" disregard any selection.

=if(LinkedAccountId='123',trim(subfield(subfield(ItemDescription, 'Sign up charge for subscription: ', 2),',', 1)))

Re: Set Expression for Calculated Dimension

Anil_Babu_Samineni — Thu, 06 Jul 2017 16:05:35 GMT

May be this?

=Only({1} if(LinkedAccountId='123',trim(subfield(subfield(ItemDescription, 'Sign up charge for subscription: ', 2),',', 1))), ItemDescription)

Re: Set Expression for Calculated Dimension

sunny_talwar — Thu, 06 Jul 2017 16:38:05 GMT

What is your expression? I think you need to use set analysis in your expression. Assuming it is Sum(Measure), change it to Sum({1} Measure)

Re: Set Expression for Calculated Dimension

Thu, 06 Jul 2017 18:31:47 GMT

This is my expression.

=if(LinkedAccountId='123',trim(subfield(subfield(ItemDescription, 'Sign up charge for subscription: ', 2),',', 1)))

I'm not trying to calculate sum or any calculation. Want to have it as my dimension.

Re: Set Expression for Calculated Dimension

Anil_Babu_Samineni — Thu, 06 Jul 2017 18:49:06 GMT

May be two options over Front End

1) Lock the Field

2) Read only option

Re: Set Expression for Calculated Dimension

Thu, 06 Jul 2017 18:50:17 GMT

That only works in the local edition, but not the server edition.

Re: Set Expression for Calculated Dimension

juan_patrick — Thu, 06 Jul 2017 20:17:20 GMT

Hi Samuel,

try this:

=mid(

Only( {1 < LinkedAccountId= {'123'} >} ItemDescription) 1,2

)

where 1 and 2 are parameters of mid function.

Re: Set Expression for Calculated Dimension

sunny_talwar — Fri, 07 Jul 2017 00:59:19 GMT

Where exactly are you trying to do this? In a chart? What is the dimension and what is the expression? Would you be able to share an image to clarify what you have? or a sample may be?