Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

amien
Valued Contributor

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
Contributor III

Re: If statement in calculated dimension breaks the selection

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

14 Replies
kuba_michalik
Contributor III

Re: If statement in calculated dimension breaks the selection

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)

MVP
MVP

Re: If statement in calculated dimension breaks the selection

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
Valued Contributor

Re: If statement in calculated dimension breaks the selection

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

MVP
MVP

Re: If statement in calculated dimension breaks the selection

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

Current Selection Alternatives

amien
Valued Contributor

Re: If statement in calculated dimension breaks the selection

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.

Highlighted
amien
Valued Contributor

Re: If statement in calculated dimension breaks the selection

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.

MVP
MVP

Re: If statement in calculated dimension breaks the selection

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

amien
Valued Contributor

Re: If statement in calculated dimension breaks the selection

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

Re: If statement in calculated dimension breaks the selection

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