Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor II

Re: How to Arrange varibles in incremental load in Qlikview?

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

Re: How to Arrange varibles in incremental load in Qlikview?

Thanks Jyothish

Not applicable

Re: How to Arrange varibles in incremental load in Qlikview?

hi

in script write this-

Let  vMindate = min(Date);

Let  vMaxdate = max(Date);

Not applicable

Re: How to Arrange varibles in incremental load in Qlikview?

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

Re: How to Arrange varibles in incremental load in Qlikview?

hi

try this

Let  vMaxdate = max(Date);

sql select  '$(vMaxdate)' from table;

vishalwaghole
Valued Contributor II

Re: How to Arrange varibles in incremental load in Qlikview?

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
Honored Contributor II

Re: How to Arrange varibles in incremental load in Qlikview?

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
Honored Contributor II

Re: How to Arrange varibles in incremental load in Qlikview?

In script also you can  write

Let vMindate=min(Date);

Let vMaxdate=max(Date);

Both method works.

Regards

KC

Best Regards,
KC
Community Browser