Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Expression for Calculated Dimension

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)))

7 Replies
Anil_Babu_Samineni

May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

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)

Not applicable
Author

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.

Anil_Babu_Samineni

May be two options over Front End

1) Lock the Field

2) Read only option

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

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

juan_patrick
Creator
Creator

Hi Samuel,

try this:

=mid(

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

         )



where 1 and 2 are parameters of mid function.

sunny_talwar

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?