Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
Hi ,
In current selection alternatives , i i want to omit some field is it possible?
Thanks
Khushboo
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
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
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
same post :
Current Selection Alternatives
Here if we can restrict straight table for one field it will be helpful.
Thanks
Khushboo
This worked with a condition within the dimension like this:
=if($Field <> 'FieldOne', $Field)
and then suppressing NULL within these dimension.
- Marcus