topic Re: How to remove a dimension from a Graph with macro in QlikView

How to remove a dimension from a Graph with macro

Thu, 07 Jan 2016 09:14:43 GMT

Hello World 🙂

i need help for deleting dimensions and expressions from a Graph with macro...

It' possible to develop a macro that allows to delete a dimension knowing only the name of the dimension?

There is a way to get the index of a dimension knowing only the name of the Dimension?

Please see the attached file.

Thak you all.

Raffaele

Re: How to remove a dimension from a Graph with macro

Chanty4u — Thu, 07 Jan 2016 09:41:02 GMT

hi,

https://community.qlik.com/message/352810#352810

chk abve thread might help

Re: How to remove a dimension from a Graph with macro

Thu, 07 Jan 2016 10:06:18 GMT

Thanks but I had already seen this tread but does not solve my problem...

Re: How to remove a dimension from a Graph with macro

HirisH_V7 — Thu, 07 Jan 2016 10:09:28 GMT

Hi ,

Conditional dimension display with macro

Hope this helps you out,

Hirish

Re: How to remove a dimension from a Graph with macro

Anonymous — Thu, 07 Jan 2016 10:18:34 GMT

check these threads:

how to move dimensions using macro?

Add/Remove Dimension based on selection

Changing Chart dimension with a macro

Re: How to remove a dimension from a Graph with macro

marcus_sommer — Thu, 07 Jan 2016 12:05:33 GMT

Are you really sure that you need macro-routines which delete dimensions and maybe also create which one or even whole objects - quite often you could get similar results if you used objects with conditions on the objects, dimensions and expression.

- Marcus

Re: How to remove a dimension from a Graph with macro

Peter_Cammaert — Thu, 07 Jan 2016 12:38:36 GMT

Don't use macros, use 'Conditional Show'. That one will work in the AccessPoint too.

Re: How to remove a dimension from a Graph with macro

Thu, 07 Jan 2016 13:16:52 GMT

i know... but this is the request of our customer:

1. Starting from an empty graph

2. Ad Dimensions to the graph (by clicking a different button for each dimension)

3. Add Expressions to the graph (by clicking a different button for each expression)

4. Save Configuration duplicating the graph

so i can't use conditional show.

I can easily add dimensions and expressions to my object but i can't remove them because i'm expected to state dimensions and expressions index and not their names.

thanks

Re: How to remove a dimension from a Graph with macro

marcus_sommer — Thu, 07 Jan 2016 16:14:30 GMT

Does your customer know that there are other possible ways to create and use dynamic charts? What are the features which only a macro provided - I didn't understand your fourth point with "save configuration" - what will be saved for which reason?

- Marcus

Re: How to remove a dimension from a Graph with macro

Fri, 08 Jan 2016 10:11:15 GMT

Found the solution.

Function gestiscidimensione()
dim i, titolo, ud
sChartId = "personalizzata"
set table = ActiveDocument.GetSheetObject(sChartId)
ud = table.GetProperties().Dimensions.count-1
if (ActiveDocument.Variables("b_dimensione").getcontent.string)=1 then

Table.AddDimension (ActiveDocument.Variables("v_dimensionebld").getcontent.string)
set cp = table.GetProperties
set dims = cp.Dimensions
dims(dims.Count-1).Title.v = (ActiveDocument.Variables("v_dimensionebld").getcontent.string)
table.SetProperties cp

else
for i=0 to table.GetProperties().Dimensions.count-1
titolo = table.GetProperties().Dimensions.Item(i).Title.v
if titolo=(ActiveDocument.Variables("v_dimensionebld").getcontent.string) then
Table.RemoveDimension i
exit for
end if
next
end if
end Function