topic Re: Macro functions in QlikView

Macro functions

Tue, 11 Dec 2012 12:57:16 GMT

Hi ,

I want to use macro functions and I need help.

I created a button, so I want that only a part of data will be displayed after I push the button.

The field by which I would like to make selection is called 'Seat'.

Thanks,

Inna

Re: Macro functions

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 13:04:29 GMT

Hi Inna,

You don't need a macro to get that functionality. When you create a button, go to the button properties, Actions tab, Add a new one, type Selection, action Select in Field, Field is set to Seat and Search String to whatever you want to search for. Note that you can use expressions if you need to.

As a general best practice rule, always use actions instead of macros, when possible.

Hope that helps.

Miguel

Re: Macro functions

Tue, 11 Dec 2012 13:04:54 GMT

You can create a button and write a macro in add action option....

Re: Macro functions

Tue, 11 Dec 2012 13:09:05 GMT

Hi Miguel,

I can't write search string , because I have a sheet with a lot of data:table with many columns ,list boxes etc.

So in this occurence how can I write this selection?

Thanks,

Inna

Re: Macro functions

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 13:14:23 GMT

Inna,

If I got the question right, you want to make some selections in the field Seat. If that is corrrect, you can set as search string

(Value1|Value2|Value3)

Or use the Concat() function to get as many values as you need.

='(' & Concat(DISTINCT FieldWithValues, '|') & ')'

If this does not help, please post some sample data and what you expect to see to make sure we get it right next time.

Hope that helps.

Miguel

Re: Macro functions

Tue, 11 Dec 2012 13:24:25 GMT

Hi, no this is not the question.

I have data display in Qlikview model like in the file attached.

I want to add a button near button yesterday.

The new button will act as following: when I press it only M1 data (yearmonth,imps) will be displayed (like in the file in explanation).

Hope now it is clear.

Thanks,

Inna

Re: Macro functions

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 14:33:35 GMT

Hi Inna,

I'm afraid I'm missing something here. If the field is called Seat, and so it seems after looking at the file attached, if you select the value M1 you will see the corresponding value for impressions, just as if you do clicking on the M1 cell in the chart.

Is that right?

Miguel

Re: Macro functions

Tue, 11 Dec 2012 14:41:34 GMT

Right, Miguel:)

But users want a separate button for that...

Re: Macro functions

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 15:19:29 GMT

Ok,

So, the thing now is to find out which values the users have to see and how many buttons do you want for them. I think that this can be achieved using actions instead of macros, but let's see...

Miguel