topic How to give a name for expression in PivotTable? in QlikView

How to give a name for expression in PivotTable?

Mon, 04 Oct 2010 13:55:02 GMT

Label for expression is like

='Current period'&Month

I want to use this expression for calculation later

How to give a name for expression in PivotTable?

Mon, 04 Oct 2010 14:09:40 GMT

Hi,

Your expression is correct. But If there are more than one values for the Month it will display blank.

To test this make a Listbox for the field Month then select one month; that will be the time that the month will be displayed in label.

You can use this code instead:


='Current Period ' & GetFieldSelections(Month)

Regards,

Nadsky

How to give a name for expression in PivotTable?

syed_muzammil — Mon, 04 Oct 2010 14:13:32 GMT

Hi,

Better use Column(Column Number of the Label) function wherever you want to use the label in another expression.

Regards,

Syed.

How to give a name for expression in PivotTable?

Mon, 04 Oct 2010 16:41:40 GMT

If you are going to use the same expression in more than one place, and especially if it is a complex expression, then it is a good idea to put the expression text into a document variable. The use the variable name whereever you would use the expression. This not only guarantees that the expression coding is the same in multiple places it also gives you a method for changing the expression in all of those places at once when you change the text in the variable.

How to give a name for expression in PivotTable?

Mon, 04 Oct 2010 22:19:33 GMT

Eureka. Thanks you Tim.

At last you've answered a collaboration problem that has been rolling around in my head for some time. How to offer users powerful calculation self-sufficiency without extensive epression training? Most can understand + - / * .

So this sum({$<Year = {$(=max(Year))}, Period = {"<=$(=max({<Year={$(=max(Year))}>} Period))>$(=max({<Year={$(=max(Year))}>} Period)-1)"}>} [Sales Amount])

Become this =CurrentMonthSalesThisYear

And this sum({$<Year = {$(=max(Year))}, Period = {"<=$(=max({<Year={$(=max(Year))}>} Period))"}>} [Sales Amount])

Become this =YTDSalesThisYear

Thanks Again

Rich De Rocco

How to give a name for expression in PivotTable?

Tue, 05 Oct 2010 07:12:14 GMT

Hi Tim! I'm a novice in QlikView. I try to make a variable in script like this

set obor=sum(Outcome)/(sum(Salary)/count(DDay))

where Outcome,Salary and DDay are fields.

so, I have PivotTable with expression sum(Outcome)/(sum(Salary)/count(DDay)) (this works) and

expression like =obor - that dont. I try also $(obor) and simply obor - anything works. 😞

Can You help me?

How to give a name for expression in PivotTable?

Tue, 05 Oct 2010 07:50:11 GMT

Thats OK with this code - I forget to post ; after set statement, so expression becomes wrong

Thanks Tim!