topic Title as a variable in QlikView

Title as a variable

t_hylander — Fri, 05 Nov 2010 12:22:19 GMT

Just wondered if there is some variables built in that stores "Title", so I can access it inside a expression.

ie I have a lot of expressions in a chart and I want to copy this into several copies. If I could just change the Title and then use a variable in the expression I wont have to edit the expressions every time I copy the chart.

ex. expression:

if(count(distinct [Title-variable])=1

Hope anyone understand what Im after.

Thanks!

Title as a variable

Miguel_Angel_Baeyens — Fri, 05 Nov 2010 12:50:16 GMT

Hi,

In some cases I use the expressions in excel spreadsheets or even hardcoded in the load script, specially when this variables are going to be used in a lot of different places or files, and then I retrieve them with

$(include=expressions.qvs);

This expressions.qvs file may contain

SET vCurrentMonthSales = SUM({< ActualMonthFlag = {'-1'} >} Sales);

Now it may be used in a chart using

$(vCurrentMonthSales)

as expression.

Hope that helps.