topic Re: Current Selection Display in QlikView

Current Selection Display

Sat, 18 Jul 2015 18:10:56 GMT

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

Re: Current Selection Display

sunny_talwar — Sat, 18 Jul 2015 18:32:43 GMT

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.

Re: Current Selection Display

marcus_sommer — Sat, 18 Jul 2015 19:39:48 GMT

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

Re: Current Selection Display

Wed, 30 Sep 2015 07:50:49 GMT

Hi ,

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

Thanks

Khushboo

Re: Current Selection Display

marcus_sommer — Wed, 30 Sep 2015 08:27:17 GMT

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

Re: Current Selection Display

Wed, 30 Sep 2015 08:36:13 GMT

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

Re: Current Selection Display

marcus_sommer — Wed, 30 Sep 2015 08:42:32 GMT

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

Re: Current Selection Display

Wed, 30 Sep 2015 09:30:38 GMT

same post :

Current Selection Alternatives

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

Thanks

Khushboo

Re: Current Selection Display

marcus_sommer — Wed, 30 Sep 2015 09:51:01 GMT

This worked with a condition within the dimension like this:

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

and then suppressing NULL within these dimension.

- Marcus