topic Bypassing field while storing the value in variable in QlikView

Bypassing field while storing the value in variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Every One,

I am storing a value into a Variable, like this..

Variable = chr(39)& Concat(Distinct Date,',') &chr(39)

Now if I select any field say CustomerID, then variable value should not change.

Any idea, how I can achieve same?

Will Only() serve the purpose?

sunny_talwar — Tue, 08 Mar 2016 11:26:28 GMT

May be this:

Variable = chr(39)& Concat({1} Distinct Date,',') &chr(39)

Variable = chr(39)& Concat({<CustomerID>} Distinct Date,',') &chr(39)

Anonymous — Tue, 08 Mar 2016 11:32:55 GMT

Above expression will return all Date from data

This works..

Variable = chr(39)& Concat({<CustomerID>} Distinct Date,',') &chr(39)