Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
Can we have a customized label for fast change.
I.e. when we set fast change a icon will be displayed on the title bar of a chart and when we hover on it, it shows "fast change".
My requirement is can we have a customized label that when we are going for a graph it should show "graph" and when we are going for pivot or straight table it should show "table".
KK
Hi Kiran,
I think there is no such direct function in Qlikview to get the type of chart currently displaying. Check this thread hope it helps you.
http://community.qlik.com/message/640923#640923
Regards,
Jagan.
Hi,
We can get the chart type by using below macro
Macro to get fast change chart type in a variable
10 - Pivot Table
11 - Straight Table
12 - Bar
15 - Line
Sub GetChartType()
set chart = ActiveDocument.getsheetobject("CH01")
set p = chart.GetProperties
set v = ActiveDocument.GetVariable("vFastChangeChartType")
v.SetContent chart.GetObjectType,true
end sub
but we cannot trigger this macro when fast change is applied. So, better create separate charts and then show and hide based on the button clicks.
Hope this helps you.
Regards,
Jagan.