topic Re: Storing Straight Table Column Name as Variable in QlikView

Storing Straight Table Column Name as Variable

Mon, 12 Sep 2011 19:06:57 GMT

Hi Everyone,

I currently have a straight table with a series of mini-charts displaying data, however I was wondering if it were possible to store a column name as a variable on a mouse click even if it is an expression in the chart. I am hoping to use the variable to display a dynamic chart across all my customers based on the selected metric.

Please let me know if you need clarification and thanks in advance for your help.

Storing Straight Table Column Name as Variable

its_anandrjs — Mon, 12 Sep 2011 19:22:29 GMT

Hi,

Use Getfieldselections( ) command to fetch the field.

HTH

Regards

Anand

Re: Storing Straight Table Column Name as Variable

Mon, 12 Sep 2011 19:27:05 GMT

Hi,

i hope this little example help u if this is that u are looking for

C u,

Stefano

Re: Storing Straight Table Column Name as Variable

its_anandrjs — Mon, 12 Sep 2011 19:39:09 GMT

Hi,

See the attached sample file you may be use some thing like this

Data:

LOAD * INLINE [

ColA, ColB, ColC

A, 145, 14

B, 125, 23

C, 242, 85

];

Rotate:

LOAD * INLINE

[

Field

ColB

ColC

];

HTH

Regards

Anand

Re: Storing Straight Table Column Name as Variable

its_anandrjs — Mon, 12 Sep 2011 19:42:54 GMT

Hi,

Store selection value into variable like

vTest = Getfieldselections( Field )

and get this value in expression and calculate

= Sum( $ ( vTest ) )

and use a load with

Data:

LOAD * INLINE

[

ColA, ColB, ColC

A, 145, 14

B, 125, 23

C, 242, 85

];

Rotate:

LOAD * INLINE

[

Field

ColB

ColC

];

See the attached

HTH

Regards

Anand

Re: Storing Straight Table Column Name as Variable

its_anandrjs — Mon, 12 Sep 2011 20:14:19 GMT

Hi,

You got correct answer with this solution.

Regards,

Anand

Re: Storing Straight Table Column Name as Variable

Mon, 12 Sep 2011 21:32:36 GMT

Hi everyone,

Thank you for the replies. I guess to more succinctly explain my problem: I have a straight table and I would like a variable trigger (or its equivalent) on selecting an expression value (or it's header) within the table. Is this possible? I know it is possible with a field, but what about with an expression or header?

Thanks,

Uller

Storing Straight Table Column Name as Variable

Mon, 12 Sep 2011 21:46:28 GMT

If I understand u can use "Group option" in the tab expression of the table.

So u can switch beetwen your expressions by clicking on the icon in the table...

Stefano.

Re: Storing Straight Table Column Name as Variable

Tue, 13 Sep 2011 05:36:56 GMT

Hi,

Please see if the attached sample can help you.

Cheers.