topic Re: Using Formulas as GroupHeaders in Qlik NPrinting

Using Formulas as GroupHeaders

ryk_budzynski — Tue, 17 Mar 2020 20:40:38 GMT

Hi All

I'm trying to use a formula as the value in a GroupHeader cell in PxP. The formula works fine elsewhere in the report but it throws the attached error when I use it in the GroupHeader.

I've set the data binding of the cell to the formula as shown in the attached.

My environment is NP April 2019 and QS Enterprise April 2019

Any help would be greatly appreciated.

Thanks, Ryk.

Re: Using Formulas as GroupHeaders

Lech_Miszkiewicz — Mon, 25 Nov 2019 03:32:18 GMT

Hi Ryk,

It is hard to say what you have wrong there. In short: Ït works for me.

As the error points to filters - do you have any filters there (task, reports or recipient filters)?

the other thing is that you have it (I believe) in the level. Is the level field or table? Does it use the same field you try to use in your formula?

btw - try just dragging and dropping your formula to header band instead of using table object as formula placeholder

Re: Using Formulas as GroupHeaders

ryk_budzynski — Mon, 25 Nov 2019 05:05:08 GMT

Hi Lech

No filters - the only thing I have is that the report cycles over the'Branch' field.

My DetailReport band was added using a level (which was the table from Sense). And as you said, the GroupHeader was just a table object where I've made it have the same number of columns as the table from Sense.

I'll try just the drag option and let you know.

Thanks, Ryk.

Re: Using Formulas as GroupHeaders

Lech_Miszkiewicz — Mon, 25 Nov 2019 05:10:46 GMT

Hi,

Cycle report could potentialy cause this issue as it is equivalent of filter...

I will do some more testing on my end with Cycle turned on.

regards