topic Re: keep possible values macro in QlikView

keep possible values macro

Fri, 14 Nov 2014 15:08:37 GMT

Hi everyone

is there a way to keep possible values in macro?

thanks for any ideas!

SUB KeepPossibleOnly
ActiveDocument.Fields("Stredisko.Popis").Select "B2B"

'FILE->File->Reduce Data->Keep Possible Values.

END SUB

morgankejerhag — Sat, 15 Nov 2014 11:34:41 GMT

Does ActiveDocument.ReduceData do what you want? If you have a selection before calling the function it behaves like Keep Possible Values.

Sat, 15 Nov 2014 12:08:44 GMT

Indeed, ActiveDocument.ReduceData will keep possible values.

If you want to remove all values from document you'd write:

ActiveDocument.RemoveAllData

Tue, 18 Nov 2014 06:33:48 GMT

Thanks, that's it. Is there any documentation where I can find this? Something like java api for java or msdn for C#

Tue, 18 Nov 2014 08:07:46 GMT

You can find helpful info in the APIGuide.qvw.

Under Automation Examples tab, search for object properties and you can find how to write them in the macros.

Thu, 20 Nov 2014 11:16:31 GMT

Thanks, that was what I looking for

hectorgarcia — Fri, 22 May 2015 17:59:20 GMT

thanks very usefull (specially when you are re generating data based on binary loads