topic Re: Change expression based on cyclic group in QlikView

Change expression based on cyclic group

Thu, 16 Jan 2014 16:13:54 GMT

Hello,

Is there possibly a way for the user to choose what field to investigate in the expression (for my purposes in a pivot table)?

For example, I have a cyclic group with fields, say field1, field2, field3.

In the pivot table, I want to display the null count for each field as I cycle through, but if I make the expression NullCount(field1), I would have to go back into the expressions box and change the inside of the NullCount(____) to field2 or field3 whenever I want to look at the different null counts.

Is there a way to make the expression read something like NullCount(group), where the group cycles through the corresponding fields?

Thanks for the help!

Re: Change expression based on cyclic group

jerem1234 — Thu, 16 Jan 2014 16:17:40 GMT

Try the GetCurrentField() function:

GetCurrentField(Group1)

Hope this helps!

Re: Change expression based on cyclic group

Anonymous — Thu, 16 Jan 2014 16:32:20 GMT

Hi Stephen,

Try this expression : NullCount( GetCurrentField( GroupName ) )

Hope this helps,

Quentin

Re: Change expression based on cyclic group

jaimeaguilar — Thu, 16 Jan 2014 16:40:37 GMT

Hi,

just to mention when you refer to the Group Name as in GetCurrentField(Group1) or NullCount( GetCurrentField( GroupName ) ), the group name will be underlined as if it was a mistake but is just a bug with syntax highlighting, so it should work,

regards