topic Asign Max Number [1-100] throught Marco in QlikView

Asign Max Number [1-100] throught Marco

Mon, 17 May 2010 10:50:57 GMT

I want to asign value of Max Number [1-100] throught marco is that possible, if yes please give me example code and

Max Number [1-100] is found in chart properties- in General Tab choose Striaght Table and then Presentation Tab.

I have API example application but i didnt found above mention problem, if any detail API tutorial pdf guide also send to me.

Asign Max Number [1-100] throught Marco

Mon, 17 May 2010 10:56:10 GMT

Hi,

You can create a variable as "NoOfBars". Right Click on the Sheet; Go to Properties--> Add input box; move the Variable("NoOfBars") to your right. Then Right Click on the chart--> to the Presentation tab;Click on the small button on right of the Max Number and enter the below code;

=$(NoOfBars)

then whatever no entered in the input box ; will be the no of bars displayed in the chart.

Regards

Re. :Asign Max Number [1-100] throught Marco

martin59 — Mon, 17 May 2010 11:04:19 GMT

Hello,

Extract from the APIGuide :

set chart = ActiveDocument.Activesheet.CreateStraightTable
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set cp = chart.GetProperties
cp.TableProperties.MaxNumberShown = 25
chart.SetProperties cp

Martin

Asign Max Number [1-100] throught Marco

Mon, 17 May 2010 11:09:01 GMT

Thankyou very much, I did.

Re. :Asign Max Number [1-100] throught Marco

Mon, 17 May 2010 11:11:37 GMT

Thankyou very much, Dear Martin do you have any pdf regarding API.

Re. :Re: Re. :Asign Max Number [1-100] throught Marco

martin59 — Mon, 17 May 2010 13:39:32 GMT

You have got an application in your installation folder. By default :

C:/Program Files/QlikView/Documentation/API guide.qvw

If you have'nt got it, tell me, i'll send to you

Re. :Re: Re. :Asign Max Number [1-100] throught Marco

Tue, 18 May 2010 05:28:21 GMT

Thanks dear I have, I want more if any in pdf format.

Re. :Re: Re. :Asign Max Number [1-100] throught Marco

Tue, 18 May 2010 05:37:12 GMT

Dear Martin, can u guide me regarding below problem:

for example I have a text file name abc.txt in root directory or where else, which has two columns and four rows, data is given below:

Col1 Col2

A 4

B 5

C 6

D 7

====================================

and in application I have four input box name A, B, C and D, now I want when I press the macro button

then its read abc.txt file and put the values in input boxes according to A,B,C & D, is that possible ?

Asign Max Number [1-100] throught Marco

Tue, 18 May 2010 07:37:32 GMT

Hi,

If i understood your question properly, below is the solution for your question.

Creat 4 variables and assign them to input box.

In Inputbox under "Constraints Tab" --> "Settings for Selected Varaiable" input this following expression.

sum(if(Col1 = 'A',Col2))

And to check the input box behaviuor , change the value at back end and press reload button to get the new values in input box.

Check the attached application

Hope this will help you.

- Peterson