topic Re: Pick field/column name from a variable and use it in calculations in QlikView

Pick field/column name from a variable and use it in calculations

Sat, 02 Nov 2013 14:11:49 GMT

Can someone please let me know is it possible to pick column name from variable and use it in set analysis?

I have created a drop down and added 4 -5 column names and when user selects any column from dropdown it calculates on the basis of that something like

=Count(Distinct {<{(year_col) = {$(year)}>} IDS)

Thanks a lot for support

Re: Pick field/column name from a variable and use it in calculations

swuehl — Sat, 02 Nov 2013 14:15:45 GMT

Might be possible if you use dollar sign expansion for that, something like

=Count(Distinct {< $(year_col) = {$(year)}>} IDS)

where year_col needs to be your variable and must expand to a valid field name.

Re: Pick field/column name from a variable and use it in calculations

Sat, 02 Nov 2013 14:40:35 GMT

not working i tired

Re: Pick field/column name from a variable and use it in calculations

swuehl — Sat, 02 Nov 2013 14:43:05 GMT

Could you post a small sample?

Re: Pick field/column name from a variable and use it in calculations

Sat, 02 Nov 2013 14:44:39 GMT

sure how can i add a file here

Re: Pick field/column name from a variable and use it in calculations

swuehl — Sat, 02 Nov 2013 14:52:21 GMT

Use the advanced editor, there is an 'Attach file' option. Follow the link on the upper right corner in standard editor, or it should be the default editor when you edit an existing post.

Re: Pick field/column name from a variable and use it in calculations

Sat, 02 Nov 2013 14:59:48 GMT

Please click on below link to download the file

https://app.box.com/s/0jirug441a1wmhvh4dqt

Thanks

Re: Pick field/column name from a variable and use it in calculations

Clever_Anjos — Sat, 02 Nov 2013 15:05:47 GMT

=Count(Distinct {<{$(year_col) = {$(=year)}>} IDS)

Re: Re: Pick field/column name from a variable and use it in calculations

swuehl — Sun, 03 Nov 2013 00:57:49 GMT

Your application works in principle. You just need to quote the year field names in your script to get the data correctly loaded in. There was also a typo in your expression 'sales' instead 'Sales'.

Re: Re: Pick field/column name from a variable and use it in calculations

Sun, 03 Nov 2013 07:40:27 GMT

Many thanks fro your help I wll try it.