topic variables in QlikView

variables

Wed, 20 Nov 2013 15:46:54 GMT

Is it possible that for any Kpi i will be given a different value for F3.

Ie I want each Kpi will be variable that I can choose a different value and it effect the chart Table like now but with variable

Pls see attachement

Re: variables

Wed, 20 Nov 2013 16:16:35 GMT

Hi ,

Yes , you can use a macro on click of button with inputbox message .

Regards

Yusuf

Re: variables

Thu, 21 Nov 2013 07:11:05 GMT

Tnx Yusuf,

I'm new with macro, can you Pls be more specific

Re: variables

Thu, 21 Nov 2013 07:19:43 GMT

Hi,

Check this attach file and if your requirement is not fulfil then let me know.

Regards,

Ashutosh

Re: variables

Thu, 21 Nov 2013 07:36:21 GMT

it doesnt help, i need that for each Kpi i will have a different variable

Re: variables

Thu, 21 Nov 2013 07:41:34 GMT

Hi,

clear one thing, Kpi mean KpiID ?

thanks

Ashutosh

Re: variables

Thu, 21 Nov 2013 07:46:46 GMT

Hi ,

Please find the attachment with the fix.

here no macro is required.

Regards

Yusuf

Re: variables

Thu, 21 Nov 2013 07:54:50 GMT

yes Kpi mean KpiID.

i need that the Filed F3 will be INPUTFIELD is it possible ?

Re: Re: variables

Thu, 21 Nov 2013 08:06:15 GMT

Hi,

I don't think so you have to create variable for every KPI because its not good way to do also. You can do in this way also.

Check attach file and let me know.

Regards,

Ashutosh

Re: variables

sivarajs — Thu, 21 Nov 2013 08:25:35 GMT

Yes you can create F3 as inputfield

Declare in script before the table.

Inputfield F3 ;

Note: In table box it will accept numbers as well text. But in chart you need to use inputsum(F3) to get the input functionality and it will accept only numbers. So you can give user a seperate table box to enter input and it will have effect on chart as well.