topic Re: how to declare a variable ? in QlikView

how to declare a variable ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want to compare two years sale ie the current year should be the 2017 and prev year should be either 2016,2015 or any other year less that 2017

so in my script i have declared my variable as :-

Let currentdate =DATE(Today(1)-1,'YYYYMMDD');

Let Curr_Year = Year(Today());

let prev_year=..............

createdate is a column in database

Date#(CreateDate, 'YYYYMMDD') as Sold_Date,
month(Date#(CreateDate, 'YYYYMMDD')) as Sold_Month,
year(Date#(CreateDate, 'YYYYMMDD')) as Sold_Year,

in my expression i have expression for prev_year and curr_year

curr_year expression:-

=num(
sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))/Sales_INR_Unit,
'#,##0.0')

for prev_year

=num(
sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value]))/Sales_INR_Unit,
'#,##0.0')

Now what all changes are required for prev_year expressions? and for prev_year variable declration????????

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 06:19:29 GMT

Please have a look addyears - script and chart function ‒ Qlik Sense

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 06:31:10 GMT

But how to use this in my script?

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 06:38:33 GMT

Why not like below

LET prev_year= AddYears(Your Intend, -1);

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 07:07:55 GMT

but i think it will give me result as 2016

but i want on input of a year in input box, the chart should start showing the appropriate result

for eg if i input 2015 in input box the results should be shown on chart

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 07:12:19 GMT

True, You can simply the expression like Variable as Input box and call that variable in Front End of each Report until unless it won't. That means little in detail

LET Var = Max(Year);

So, In your list box it has Var as "Used Variables"

And then, the analysis need to be changes as per input from customer. So you have to enable like

Sum({<Year = {$(=Var)}>} Sales) // this deserve, If we add manually input from input box..

Does it make sense..

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 07:14:01 GMT

This is not functioning

i have used

Let Prev_Year = AddYears(Date,2);

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 07:16:38 GMT

Let's consider Date has 12/12/2017, 11/12/2017..

How and Which Date field picks to go backward.. That means, you have to use Max() and Min() to get into work..

Note - If none of them make sense for you i would suggest please come up with example and explain same as needed

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 07:37:40 GMT

now how to use max iand min in sa,me above varialable declaration?

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 08:38:31 GMT

Not sure, Your thread is different and your conclusion is different. May be this?

Let Prev_Max_Year = Date(AddYears(Max(Date),2));

Let Prev_Min_Year = Date(AddYears(Min(Date),2));

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 08:56:34 GMT

its giving an error

syntax error

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 08:57:45 GMT

What you've done? Can you share image?

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 09:18:20 GMT

Let Prev_Year = AddYears('2017-10-12',-2);

when i am using this in variable

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 09:20:26 GMT

What you shown is working?

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 09:21:52 GMT

now yo want me to use these variables instead of these?

Let currentdate =DATE(Today(1)-1,'YYYYMMDD');
Let Curr_Year = Year(Today());
Let Prev_Year = (Year(Today())-1);

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 09:24:31 GMT

variable used in text box is working but charts are not showing results, it can be seen in image

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 09:24:56 GMT

Yes? You can play with that your needed. Because, Still 100's reply are not helpful if thread owner not explaining clear and needed

Re: how to declare a variable ?

Anonymous — Thu, 14 Dec 2017 09:25:43 GMT

actually i dont want entire date. i only want year to like instead of 10/12/2015. i want only 2015

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 09:26:08 GMT

How come i know what expression you attempt?

Re: how to declare a variable ?

Anil_Babu_Samineni — Thu, 14 Dec 2017 09:27:26 GMT

What we try everything available from Qlikview Cookbook | Recipes for Qlikview Success