topic Re: Action setting a variable as dimension in QlikView

Action setting a variable as dimension

canmarroig — Thu, 22 Jun 2017 19:27:58 GMT

Hi, i need to create a button with an action:

if i want to set my date >= to a certain variable i can find my data set ='>='&'$(vMaxDate)'

if my date is only = to my variabile there's no action ='='&'$(vMaxDate)'

Can you help me?

Tks

Re: Action setting a variable as dimension

sunny_talwar — Thu, 22 Jun 2017 19:31:50 GMT

I guess you are saying that this works

='>='&'$(vMaxDate)'

but this doesn't

='='&'$(vMaxDate)'

Is that right?

Try this may be

=$(vMaxDate)

Re: Action setting a variable as dimension

canmarroig — Thu, 22 Jun 2017 19:54:21 GMT

No i've tried:

=$(vMaxDate)

also

vMaxDate

and since my variabile is a numeric value i've also tried =date(vMaxDate), not at all.

Why with '>=' it's ok?

Action setting a variable as dimension

Re: Action setting a variable as dimension

sunny_talwar — Thu, 22 Jun 2017 19:56:32 GMT

Do you have a timestamp by chance? or is it 100% a date field?

Re: Action setting a variable as dimension

canmarroig — Thu, 22 Jun 2017 20:11:16 GMT

No timestamp

Re: Action setting a variable as dimension

sunny_talwar — Fri, 23 Jun 2017 01:08:51 GMT

Would you be able to share a sample to check what you might be doing incorrectly?

Re: Action setting a variable as dimension

patrickanderson — Fri, 23 Jun 2017 03:14:48 GMT

I would just try ='$(vMaxDate)'

Re: Action setting a variable as dimension

canmarroig — Mon, 26 Jun 2017 08:12:50 GMT

I've tried also this syntax but i've still problem

Re: Action setting a variable as dimension

antoniotiman — Mon, 26 Jun 2017 08:30:07 GMT

Hi Anna,

assuming

vMaxData =Max(DateField)

have You tried

=vMaxData

Re: Action setting a variable as dimension

BalaBhaskar_Qlik — Mon, 26 Jun 2017 08:38:11 GMT

Try:

='>=' & $(vMaxDate)

='=' & $(vMaxDate)

Re: Action setting a variable as dimension

canmarroig — Mon, 26 Jun 2017 08:50:05 GMT

I've found, it's possibile only if i set

=date(vMaxDate)

vMaxDate is a numeric date, but i still guess why

='>='&'$(vMaxDate)'

run correctly

Thank you!