topic Re: Concat Issue - II in QlikView

Concat Issue - II

kishorj1982 — Wed, 06 Apr 2016 17:52:29 GMT

Started new thread as original has already been marked as correct.

HI Stefen.

last time you have provided the solution to the issue above where I wanted to add and append selected fields from one state to another. I have worked on the same lines to remove the selection from the another state with diff button action

It works fine in my application.

But it shows formula in the current selections instead of the actual selections. To get rid off it I have added one more button action - "Select Possible" IN the intended field. But its not giving correct results when I am removing selections from another button.

Can you please let me know how to display the actual selections in the current selections box rather than Formula...that too without using the SELECT POSSIBLE additional action ?

Attached is the sample application

Re: Concat Issue - II

swuehl — Wed, 06 Apr 2016 18:05:22 GMT

Is this the correct file you attached? AFAIR, we used different search strings, and I don't see a remove button etc.

Also it's not really clear in which fields I am supposed to select and which sequence of actions I am supposed to do.

Re: Concat Issue - II

kishorj1982 — Wed, 06 Apr 2016 18:55:01 GMT

HI Stefen,

Please find attached -new file.

Actions :

For 1st time selection from State A Table --> State B Table -- Use button : Add to List (A -- > B) -1st time

For subsequent Selections : from State A Table --> State B Table -- Use button : Add to List (A -- > B) 2

To remove selections : Here, you have to select in state B and hit Button : Remove List-2.

Please look into it. I also want to highlight the selections in STATE A .

Please help

Re: Concat Issue - II

swuehl — Wed, 06 Apr 2016 20:26:20 GMT

I think you should also select in state A FILE when you want to remove values, at least that's how it is working.

What is the exact issue with SelectPossible and removing values? I added this action to the buttons and it seems to be working ok.

Re: Concat Issue - II

kishorj1982 — Wed, 06 Apr 2016 21:02:48 GMT

HI Stefen,

Thanks. I have tried with Select possible option. But While removing users can remove selected OR unselected FILE fields from the State A table. Issue happens when user selects all the fields already selected in State B Table + unselected fields in State A table.... in that case due to select possible selects entire table in state B this defeat the whole purpose of building this functionality.

I.e. If I have A,B,C ,D in Table with state A.

and if I have selected fields A, B in Table with state B.

When I am selecting A,B and C in Table with state A for removing corresponding items from Table with state B, then it selects all the fields in Table with State B.

I dont want this to be happen.

Re: Concat Issue - II

swuehl — Wed, 06 Apr 2016 21:29:55 GMT

Try applying the SelectPossible action triggered by field OnSelect trigger.

See attached.

Re: Concat Issue - II

kishorj1982 — Wed, 06 Apr 2016 21:58:14 GMT

NO Stefen it still expands the entire table in State B. Cant we have any action in buttons itself as triggers may cause issues in many situations. I already have trigger on that field in my main application and dont want to go with that route to make it more complex.

Please suggest.

Re: Concat Issue - II

swuehl — Wed, 06 Apr 2016 22:33:28 GMT

Well, maybe these trigger are counter-productive anyway? How do these triggers and actions on that field look like?

If I select some few values and then press the first button

Then add a fifth value per second button, I get

If I then select the same values again in State A and press Remove

All selections are gone...

Re: Concat Issue - II

kishorj1982 — Wed, 06 Apr 2016 22:44:32 GMT

Yeah thanks Stefen. Just trying to understand if we can use another action instead of trigger ? IF yes - then it will be great..

Re: Concat Issue - II

swuehl — Wed, 06 Apr 2016 22:57:37 GMT

Maybe like this, using only button actions

Re: Concat Issue - II

kishorj1982 — Thu, 07 Apr 2016 01:15:08 GMT

Stefen ! Stefen!! Stefen!!! - You got Billion $ brain. Thank you very much for another solution in no time..... Thanks..

I will try this in my main application and then we can close this thread....

Thanks again bro!

By the way can you please explain the meaning of : =If(Count({<FILE -= ::FILE>} FILE),'FILE') - how it works ?