topic Clear Other Fields? in QlikView

Clear Other Fields?

Mon, 19 Apr 2010 17:17:17 GMT

Hi all,

Am I missing something with the 'clear other fields'?

For example, select from 2 unrelated listboxes then right click on one and click 'Clear Other Fields'. I expected that the selections in teh other would be clieared, but not this listbox. However, nothing happens. I tried it in 9.0 and 8.20 and the same result.

How do you use this function?

Regards,

Gordon

Clear Other Fields?

Oleg_Troyansky — Mon, 19 Apr 2010 20:48:27 GMT

Gordon,

I tried the same on ver. 9.00, and it worked just as I expected - all other selections got cleared, except for the list box that I clicked on...

How are you doing, buddy? Are you affected by the cloud?

Clear Other Fields?

Tue, 20 Apr 2010 10:00:10 GMT

Hi Oleg,

Thanks for the reply.

This is odd! Please see attched qvw created in v9sr3 which is just 3 unrelated fields in list boxes. If I select:

F1 = 3

F2 = B

F3 = 2

If I right-click F2 and select 'Clear Other Fields' nothing happens. If I click the 'Clear Other Fields' icon on the header in F2, nothing happens. If I click the button which has an action 'Clear Other Fields' nothing happens. I tried the same thing in v8.20 (without the button action) and nothing happens there either. I really must be missing something!

The cloud is causing big problems over here; I feel sorry not just for those people losing their holidays but those struggling to get home too. I live in a village about 20 miles North of Stansted, which is under the flight path and the absence of planes is very noticeable.

Mind you I always had my doubts abouts cloud computing

Regards,

Gordon

Clear Other Fields?

Tue, 20 Apr 2010 10:56:25 GMT

Hi Gordon,

the F1 and F3 field will not be cleared, because the fields are in tables, which are not linked to your F2-table.

The "Clear Other Fields"-function will only affect fields of linked tables.

Try this code:

LOAD * INLINE [
F1, F2
1, A
2, A
3, B
4, B
];

LOAD * INLINE [
F2
A
B
C
];

LOAD * INLINE [
F3, F2
X, A
Y, A
Z, B
];

Regards,

Clear Other Fields?

Tue, 20 Apr 2010 14:45:21 GMT

Thanks for that.

It was not what I was expecting as I assumed it worked like 'clear (all) other fields except for'. Perhaps a better name for the function would be 'Clear Other Related'.

I actually want to clear ALL fields with one exception; I have now tried to do this with actions 1) save selection to variable 2) clear all 3) reselect from variable but this doesnt work. It seems to be a timing thing - do actions fire one after the other without waiting for the previous to end? Attached qvw should demonstrate the problem - any ideas?

Regards,

Gordon