topic Function to determine Chart Type in QlikView

Function to determine Chart Type

sunny_talwar — Wed, 01 Jun 2016 14:02:14 GMT

Hi Team -

Has anyone come across a function to determine which chart type we are on? Something like =ChartType('Object ID')

Best,

Sunny

Re: Function to determine Chart Type

Kushal_Chawda — Wed, 01 Jun 2016 14:14:28 GMT

Possibly by Macro?

Re: Function to determine Chart Type

sunny_talwar — Wed, 01 Jun 2016 14:15:30 GMT

Do you have a code which can be used?

Re: Function to determine Chart Type

Kushal_Chawda — Wed, 01 Jun 2016 14:29:42 GMT

What is the use case here? Can't we know the chart type by simply looking at the chart?

Re: Function to determine Chart Type

smirkinaa — Wed, 01 Jun 2016 14:30:08 GMT

Hi.

I have found suitable function in API Guid.qvw. We can create macro:

Sub GetTypeObject()

SET varObject = ActiveDocument.getsheetobject("BU03")

MsgBox(varObject.GetObjectType)

End sub

then we can connect macro with button

returning code shows type of object:

0=Unknown

1=List Box

2=Multi Box

3=Statistics Box

4=Table Box

5=Button

6=Text Object

7=Current Selections Box

8=Input Box

9=Line/Arrow Object

10=Pivot Table

11=Straight Table

12=Bar Chart

13=Pie Chart

14=Scatter Chart

15=Line Chart

16=Combo Chart

17=Custom Object

18=Bookmark Object

19=Slider/Calendar Object

20=Grid Chart

21=Radar Chart

22=Gauge Chart

23=Chart Derived

24=Sheet

25=Tabrow

26=Document

27=Block Chart

28=Funnel Chart

29=Internal Layout

30=Inter Sheet Transfer

31=Search Object

32=Bookmark

33=Report

34=Slider

35=Calendar

I hope it is useful.

Re: Function to determine Chart Type

sunny_talwar — Wed, 01 Jun 2016 14:31:32 GMT

So lets say if I use fast change to switch between straight table and pivot table. When on straight table, I want to use one dimension and when on pivot table, I would like to see 2 dimensions.

Re: Function to determine Chart Type

swuehl — Wed, 01 Jun 2016 14:32:11 GMT

Maybe have a look at topic 31:

Useful Qlikview Macros

Re: Function to determine Chart Type

sunny_talwar — Wed, 01 Jun 2016 14:34:18 GMT

Hahaha it was just a google search away. I will test it out

Re: Function to determine Chart Type

swuehl — Wed, 01 Jun 2016 14:36:01 GMT

I guess the issue will be how to trigger that macro

Re: Function to determine Chart Type

sunny_talwar — Wed, 01 Jun 2016 14:37:35 GMT

I am planning to play around with it. I will respond back if I find a way to do it

Re: Function to determine Chart Type

Kushal_Chawda — Wed, 01 Jun 2016 14:38:13 GMT

Yes. Got it

Re: Function to determine Chart Type

Gabriel — Wed, 01 Jun 2016 14:54:44 GMT

Hi Sunny,

I have not tried this code before, but it looks like what you need. Hope it helps

rem ** get unique object ID for first object on sheet Main **

set s = ActiveDocument.Sheets("Main") // You can possibly have a variable to determine activesheet name

set so = s.SheetObjects(0)

id = so.GetObjectId

msgbox("ID = " & id)

Re: Function to determine Chart Type

sunny_talwar — Wed, 01 Jun 2016 15:20:50 GMT

Would you be able to share the sample here?