Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

If statement in calculated dimension breaks the selection

I have a table with conditionals shows.

The enduser can select which dimensions he wants to view.

To make it possible i have a listbox (data island) where selections can be made. This works fine.

But now i want to make it more end-user friendly (in the end solutions there are alot of fields to select), i want to split the listboxes.

I do this by adding a calculated dimension to the listbox =If(Tag = 'Order',Field)

The problem is then that is it NOT possible to select a field in both listboxes. So it's not possible to select a field in the client list and a field in the order list.

How can i solve this?

I tried to create a data-island for both client and orders. This will work, but the thing is that i need to proper sort order of the dimensions. And this is a mix of both client fields and order fields.

See attachment ! Thanks in advanced

1 Solution

Accepted Solutions
kuba_michalik
Partner - Specialist
Partner - Specialist

And here's my third and (I think) final brilliant idea

Summary: data islands, use set analysis to merge selections in data islands into a selection on the main Field field

View solution in original post

14 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

You can solve it with some Alternate States trickery (see attachment). It is a bit elaborate, though, maybe someone else has a better idea (something relying on the order of dimensions as defined in the table would be a little simpler, but I take it you want the order to be fully controlable by the #Sort value, so it wouldn't cut it).

Please note it is not possible to have the Current Selections box work with it (Current Selections cannot show selections combined over multiple states)

sunny_talwar

I tried to create a data-island for both client and orders. This will work, but the thing is that i need to proper sort order of the dimensions. And this is a mix of both client fields and order fields.

I think might be a good approach, I wonder what issue were you having with the proper sort order. Would you be able to expand on this?

amien
Specialist
Specialist
Author

Yes, i tried this, but i need all the selections in the Current SelectionBox

sunny_talwar

May be use a current selection box alternative to show selections in both inherited and alternative state:

Current Selection Alternatives

amien
Specialist
Specialist
Author

Because of this string in the dimension :

=$(=('[' & Trim(SubField(Concat(Field,'|',#Sort),'|',1))) & ']')



here is where i use the sort thing. So the first Field should be used for Dim1 in the chart. And the second field becomes Dim2. All based on the sort order. The thing is that Dim1 can be something from the Client table. While Dim2 can be in the Order Table. Therefor i need the Sort field in 1 table.

If you can create a String with all the selected field in AND the right sort order, what will be fine too.But i can only use 1 #Sort field in the Concat. #Sort is a number btw.

amien
Specialist
Specialist
Author

This might work, but not ideal, because i need to have like 25 alternate startes. It's not only Orders and Client, but alot more categories.

sunny_talwar

May be if you want the dimensions to show up in a specific order, you can try using this technique may be?

amien
Specialist
Specialist
Author

no. . because i have like 500-700 dimensions .. which makes it impossible to maintain

Gysbert_Wassenaar

Are you trying to do something like this:

Customisable Straight (and Pivot) Tables - more food for thought

User Customisable Data View with Interactive Sort Order


talk is cheap, supply exceeds demand