Current Selection Display

[#1]

Hi Experts,

I wanted to display Original names in Current selection box even its after qualifying the table

Ex:

Qualify(*)

Table:

Dim1

Dim2;

Unqualify(*)

So now I will get field names as Table.Dim1, Table.Dim2, but users are looking like Dim1, Dim2 only in Current selection.

How to do this, please let me know

Thanks

[sunny_talwar]

I don't think that is an option available.... may be use a text box object to show current selections instead of current selection box.

[marcus_sommer · Accepted solution]

I think the suggestion from sunindia is the easiest one with:

replace(getcurrentselections(chr(10), ': ', ' + '), 'Table', '')

in a textbox. But maybe these alternatives are interessting, too.

Current Selection Alternatives

QlikView App: Current Selections Dynamic Display

- Marcus

[#4]

Hi ,

In current selection alternatives , i i want to omit some field is it possible?

Thanks

Khushboo

[marcus_sommer]

I couldn't say it without a deeper look into those workarounds then I don't use them within a productive environment and my playing around was some time ago.

By a normal current selection box you would use a prefix-statement for those fields which would be then be handled like qlikview system-fields and not displayed within the box. I don't know if this or a quite similar approach worked with the alternatives but you could try it.

- Marcus

[#6]

Hi Marcus,

Thanks for your reply.

But i specifically need in he straight table  current selection box .

I have used current selection alternatives approach and now i want to restrict it for some fields.

Khushboo

[marcus_sommer]

Within a table-chart should it be possible to include such conditions - what are the dimensions and expressions which you used and which fields should be hidden and how looked the table?

- Marcus

[#8]

same post :

Current Selection Alternatives

Here if we can restrict straight table for one field it will be helpful.

Thanks

Khushboo

[marcus_sommer]

This worked with a condition within the dimension like this:

=if($Field <> 'FieldOne', $Field)

and then suppressing NULL within these dimension.

- Marcus