Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Arrange varibles in incremental load in Qlikview?

hi,

I  created a Employ table That Table have Two  Date fields ,I  Want  to Arrange Variables  that 2 Date fields But I do not know How to Create  variables in That Min Date as [Date field] and Max Date as[EDate Field]fields.Please tell me out How to Arrange variables in Qlikview. I attached Snipping files below This box.

Regards:

Madhu

Incremental Varible.JPG.jpg

Sql table.JPG.jpg

8 Replies
jyothish8807
Master II
Master II

Hi Madhu,

Go to setting----> Variable overview

Creat your variable over there and assign the value to it.

Later call those variables in to the chart,

vMindate=min(Date)

vMaxdate=max(Date)

Regards

KC

Best Regards,
KC
Not applicable
Author

Thanks Jyothish

Not applicable
Author

hi

in script write this-

Let  vMindate = min(Date);

Let  vMaxdate = max(Date);

Not applicable
Author

Jyothish,

Thank you for the answer. I want to get max(Date) from a sql query and assign to a variable......example: Let vDate=SQL select max(Date) from tablename.....please kindly let me know how to achieve this.

Thanks,

madhu

Not applicable
Author

hi

try this

Let  vMaxdate = max(Date);

sql select  '$(vMaxdate)' from table;

VishalWaghole
Specialist II
Specialist II

Hi Madhu,

You can do it by 2 ways :

Go to setting----> Variable overview

Creat your variable over there and assign the value to it.

Later call those variables in to the chart,

vMindate=min(Date)

vMaxdate=max(Date)

and

in your script

Let vMindate=min(Date);

Let vMaxdate=max(Date);

Hope it will be helpful for you.

-- Regards,

Vishal Waghole

jyothish8807
Master II
Master II

Hi Madhu,

As per my understanding you dont have to write a sql script to fetch min and max date.

Once you load data from sql server you can get min and max date simply from date field using the above method.

Regards

KC

Best Regards,
KC
jyothish8807
Master II
Master II

In script also you can  write

Let vMindate=min(Date);

Let vMaxdate=max(Date);

Both method works.

Regards

KC

Best Regards,
KC