topic GetCurrentSelections without certain fields in QlikView

GetCurrentSelections without certain fields

Fri, 16 Oct 2009 19:29:35 GMT

I need to use the function GetCurrentSelections into a text object , but without showing the selections of certain fields. Is it possible?

Thank's a lot!
Pol

GetCurrentSelections without certain fields

Fri, 16 Oct 2009 20:14:41 GMT

Maybe you could use GetFieldSelections function instead ?

Rgds,

Sébastien

GetCurrentSelections without certain fields

Fri, 16 Oct 2009 22:10:11 GMT

No... I need all the fields except three... some idea more?

thank's!

GetCurrentSelections without certain fields

biester — Sun, 18 Oct 2009 05:18:18 GMT

I know that this my question won't solve the problem, but: I don't know of a GetFieldSelections (at least don't remember it in the API-Guide - can't check now). Is there really such a function, and if yes, what exactly does it do? Are there parameters? If exactly explained, this function COULD solve the rpoblem.

Rgds,
Joachim

GetCurrentSelections without certain fields

prieper — Sun, 18 Oct 2009 08:45:05 GMT

Have not tested, but think that you might play around with the GetCurrentSelections()-formula and then try to formulate your exclusions and replace it with a combination of string-formulae, like checking for keywords and then purging the complete line.

Not a straightforward help, but may show you the way.

Peter

GetCurrentSelections without certain fields

pkelly — Mon, 19 Oct 2009 01:50:05 GMT

I had a similar problem sometime ago but was more about checking that bthe user had invoked a selection to sbhow a field.

I have mocked up a shortened version of this - don't know if this will help you or not...

The premise is to store the selection for each filter into a variable.

Steps I took...

1) Create variabl

2) Add script from Tools | Edit module (watch variable / field names)

3) Go to Tools | Document Properties | Macros (think this is Triggers in newer versions)

4) Need to look at On Change And Select filters.

In the example I have provided, the text box updates to the selection(s) made in the respective filter.

Hope this helps.

GetCurrentSelections without certain fields

Mon, 19 Oct 2009 22:39:12 GMT

hi,

thank's for the answers, but I do not manage to solve it...

I have 3 fields selected always for default, and do not want that they appear in the object of text with the GetCurrentSelections() function...

Finally I will use the GetFieldSelections with all the fields ... a lot of work!

Thank's for all the messages...

Regards,

Pol

GetCurrentSelections without certain fields

Mon, 19 Oct 2009 22:53:21 GMT

if you always have 3 fields selected, why not load your info with that filter already applied?

GetCurrentSelections without certain fields

Tue, 20 Oct 2009 16:29:41 GMT

Hi,

i don't know that this will help you with text object but i have similar problem. I didn't want to see specific field selections in SelectionBox. in the begging of the script i define: Set HidePrefix=%; and then when im loading table and fields that i dont want to appear in SelectionBox i put % sing in front of them. This works for me - fields with % sign named didn't appear when i make selection i them in SelectionBox. I don't know if this will work with GetCurrentSelections function

Edit: Also be sure that "Show system fields" check box in "Sheet properties" is not selected.

Regards!

Stefan

GetCurrentSelections without certain fields

Tue, 20 Oct 2009 17:49:43 GMT

mmm... very interesting...

I don't understand the last part, it's possible upload a example please? I define the variable, and I put the % in front of fields, but they appear too into the SelectionBox...

Which is the last step?

Thank's a lot!!
Pol

GetCurrentSelections without certain fields

Tue, 20 Oct 2009 20:58:02 GMT

The last step is to go to your Sheet Properties and uncheck the box that says 'show system fields'.

My question.... can I use HidePrefix on more than one prefix? I want to hide fields starting with % and fields starting with &.

GetCurrentSelections without certain fields

Tue, 20 Oct 2009 21:25:44 GMT

Yea forgot to mention that check box. I'm not sure that hidepreffix can be used more than once in document. I think that the last using of function is used as current.

polmar cant upload example because when i to upload error appears. If you want can send you by email?

Regards!

Stefan

GetCurrentSelections without certain fields

Tue, 20 Oct 2009 22:16:56 GMT

wow!!!

The problem has been solved! Thank you very much Stefan, is not necessary that you send the mail.

I verified your answer, but the response in this message is not complete. edit please, and complete the solution.

kmacdonald, maybe this combination of functions could solve your problem...

set HidePrefix='%';
set HideSuffix='Y';

Good job! Thanks to all the users for his contribution!

Pol