topic Table Display / Cross table data in QlikView

Table Display / Cross table data

Fri, 18 Jul 2014 13:00:58 GMT

I have roughly ten list boxes, all marked "Always one selection".

I need to display the title of each box, the current selection, and then a clickable value (associated with the current selection).

Demographic | Current Selection | Data

Men	All Races	10000
Women	All Races	12000
Households	All Races	8000

I'm having trouble getting the selections to list in this form with a straight table. Because there is another dimension from my cross table (income groups), a pivot is also causing problems.

Any suggestions for charts or expressions to trick qlik?

Re: Table Display / Cross table data

marcus_sommer — Fri, 18 Jul 2014 13:53:42 GMT

With getcurrentselections() and getfieldselections() could you return the current selections - but what for a clickable value should be created from this and why? How causing this problems with a pivot?

- Marcus

Re: Table Display / Cross table data

Fri, 18 Jul 2014 14:36:12 GMT

need something like a current selections box. can i use getcurrent.. and getfield... functions to do that with a pivot?

you cannot format a current selections box to read like a table or include values. correct?

Re: Table Display / Cross table data

marcus_sommer — Fri, 18 Jul 2014 14:48:37 GMT

Have a look on this solution: Re: Re: Re: Issue with Current selections box value on selection of dynamic buckets created in chart

- Marcus

Re: Table Display / Cross table data

Fri, 18 Jul 2014 17:51:07 GMT

That is a great example. But how can i add an expression that retrieves data linked to the selected value? Another field to the right of "Selected Value" that is calculated based on the selection in "Selected Values" field??