topic Variable in QlikView

Variable

Mon, 12 Jan 2015 09:10:33 GMT

I have a table called by name "SUbscription ", which has many columns among which there is a column name called "Airtledated" which has the formate like this

12-01-2014 , like this it has for 1 year . and in the same " Subscription table ther is a cloumn name called product and ID .

Now i want to know how do i get the start date and end date . from the date column. What kind of variable i need to define .

I already had this variable but its showing wrong its giving the date as -2021

vstartdate =date(aggr(min(Airtledated),Airtel_product))

VEnddate= date(aggr(Max(Airtledated),Airtel_product))

Will some one help me plz . Iam stcuk badly .

Thanks in Advance

Re: Variable

tresB — Mon, 12 Jan 2015 09:17:36 GMT

A variable can't hold multiple values at a time. You might have to take a different route based on your requirement.

Re: Variable

Mon, 12 Jan 2015 09:24:47 GMT

They are different variables

Re: Variable

tresB — Mon, 12 Jan 2015 09:30:16 GMT

vstartdate =date(aggr(min(Airtledated),Airtel_product))

If you are trying to get start dates for every products (your aggr() made me think so), that means your trying to store multiple values in a single variable, that is not possible. If you want start date for a single seleted product, try without aggr() like:

vstartdate =date(min(Airtledated))

Re: Variable

Mon, 12 Jan 2015 09:46:44 GMT

how to add 2 vairables ?

is it like this

=$(vstartdate)+$(vendate)

(vstartdate)+(venddate)

Re: Variable

tresB — Mon, 12 Jan 2015 09:56:36 GMT

Concatenation operator is '&', like:

=$(vstartdate) & $(vendate)

Re: Variable

Mon, 12 Jan 2015 10:09:41 GMT

does it give me the addition ?