Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks Jyothish
hi
in script write this-
Let vMindate = min(Date);
Let vMaxdate = max(Date);
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
hi
try this
Let vMaxdate = max(Date);
sql select '$(vMaxdate)' from table;
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
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
In script also you can write
Let vMindate=min(Date);
Let vMaxdate=max(Date);
Both method works.
Regards
KC