topic Get 1 field from current selection in QlikView

Get 1 field from current selection

pauldamen — Mon, 18 Mar 2013 15:37:07 GMT

Dear all,

I have a listbox with fields: Actual, Budget, LE

I also have a table with different columns which match the Actual, Budget, LE and some other calculations.

Now I want to show them conditional, if you select Actual and Budget in the listbox the columns should appear. How can I get this to work, I tried GetCurrentFields, GetCurrentSelections formulas in the conditional box but it doesn't work.

Hope you could help me.

Regards,

Paul

Re: Get 1 field from current selection

Mon, 18 Mar 2013 15:40:01 GMT

Can you upload your sample application

Re: Get 1 field from current selection

Gysbert_Wassenaar — Mon, 18 Mar 2013 15:45:50 GMT

See attached example. It uses the substringcount and concat functions.

Re: Get 1 field from current selection

pauldamen — Mon, 18 Mar 2013 15:49:10 GMT

Thanks works great!

Just for my interest could you explain what you did with the SubString and the Concat and what this does?

Re: Get 1 field from current selection

Gysbert_Wassenaar — Mon, 18 Mar 2013 15:57:51 GMT

Well, I didn't since I didn't create the document . But the concat creates a string of all the possible values of Field. And substringcount checks in the value you want is in that string. If it is then it returns true, otherwise false. That makes it handy to use for the conditional display expression.

Re: Get 1 field from current selection

pauldamen — Mon, 18 Mar 2013 16:06:03 GMT

Thanks for the clear explanation and the help!