Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Partner
Partner

Get 1 field from current selection

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Get 1 field from current selection

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Highlighted
Not applicable

Re: Get 1 field from current selection

Can you upload your sample application

Highlighted
MVP & Luminary
MVP & Luminary

Re: Get 1 field from current selection

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Partner
Partner

Re: Get 1 field from current selection

Thanks works great!

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Get 1 field from current selection

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.


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

Re: Get 1 field from current selection

Thanks for the clear explanation and the help!