Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
canmarroig
Contributor

Action setting a variable as dimension

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)'  

3.jpg

Can you help me?

Tks

Tags (3)
10 Replies

Re: Action setting a variable as dimension

I guess you are saying that this works

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

but this doesn't

='='&'$(vMaxDate)'

Is that right?

Try this may be

=$(vMaxDate)

canmarroig
Contributor

Re: Action setting a variable as dimension

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?

Re: Action setting a variable as dimension

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

canmarroig
Contributor

Re: Action setting a variable as dimension

No timestamp

Re: Action setting a variable as dimension

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

patrickanderson
New Contributor III

Re: Action setting a variable as dimension

I would just try ='$(vMaxDate)'

canmarroig
Contributor

Re: Action setting a variable as dimension

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

antoniotiman
Honored Contributor III

Re: Action setting a variable as dimension

Hi Anna,

assuming

vMaxData     =Max(DateField)

have You tried

=vMaxData

balabhaskarqlik
Honored Contributor

Re: Action setting a variable as dimension

Try:

='>=' & $(vMaxDate) 

='=' & $(vMaxDate)