Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner
Partner

Fixing Variable in Script

Hi all,

Couldn't find a solution to fix a Variable in load editor. Tried with let, set, put it in bracked, even formated in text, but the variable in the app would not stay static. The output is a date, not a dimension. 

Set vP = Date(Floor(RangeMax(Date(Max(Field1)), Date(Max(Field2)))));

Any idea?

Thanks.

 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
kashyap311996101

Hi

Try this

Date(Floor(RangeMax((Max({1}Field1)),(Max({1}Field2)))))

Hope this helps

Thanks

Thanks and Regards
Kashyap.R

View solution in original post

4 Replies
Anil_Babu_Samineni

Try this

LET vP = '=Date(Floor(RangeMax(Date(Max(Field1)), Date(Max(Field2)))))';

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kashyap311996101

Hi

Try this

Date(Floor(RangeMax((Max({1}Field1)),(Max({1}Field2)))))

Hope this helps

Thanks

Thanks and Regards
Kashyap.R
george55
Partner
Partner
Author

Thanks   , but same behaviour, variable is still dynamic

george55
Partner
Partner
Author

Thanks Kashyap, that worked!