topic Help me to write a macro.. in QlikView

Help me to write a macro..

sushil353 — Wed, 21 Sep 2011 06:55:20 GMT

Hi all,

i have a field in which data is

NDF

NDR

NDF_CLEAR

NDF_TEST

NDF_APPLICATION

i want to write macro and create 3 buttons like 1. button for NDF 2.button for NDR 3. button for NDF and NDR

if i press button 1 then only NDF get selected

if i press button 2 then only NDF and NDR get selected

and if i press button 3 then all NDF and NDR get selected

Please help me out to solve this problem..

Thanks

Sushil

Re: Help me to write a macro..

Wed, 21 Sep 2011 07:42:38 GMT

Hi Sushil,

this is taken from the ApiGuide.qvw from the "Field" class:

ActiveDocument.Fields("Month").Select "September"

ActiveDocument.Fields("Month").Select "J*"

ActiveDocument.Fields("Sales").Select ">1500"

C u,

Stefano

Help me to write a macro..

kaushiknsolanki — Wed, 21 Sep 2011 07:46:31 GMT

HI,

You dont need macro to achieve this.

All you need is a new field from the table. Let me explain in detail.

You need to do like this.

Load

Field1,

if(Wildmatch(Field1,'NDF*'),'NDF',

if(Wildmatch(Field1,'NDR*'),'NDR')) as NDF_NDR

From xyz.

Now place this field as a filter.

You will have 2 values, i.e NDF and NDR, so whenever you click on NDF the data will get filter for NDF and same like NDR. Now when you want both, then dont select anything.

So you dont require Macro.

Hope you understood.

Regards,

Kaushik Solanki