topic Re: How to Retrieve values from a variable? in QlikView

How to Retrieve values from a variable?

Thu, 21 Aug 2014 12:20:40 GMT

Hi All,

I have a variable in which comma separated values get appended. Is there any way by which I can retrieve the latest appended value and Display it in a text box?

Thanks in Advance.

Regards,

Pratik

Re: How to Retrieve values from a variable?

marcus_sommer — Thu, 21 Aug 2014 12:23:20 GMT

Try this:

subfield(YourVariable, ',', -1)

- Marcus

Re: How to Retrieve values from a variable?

Thu, 21 Aug 2014 12:52:07 GMT

Hi,

I am Using FieldValueCount function in Load Script..

Let var1=FieldValueCount(ID);

what if I want to give an if condition in Load Script?

Like if there is another dimension Dept.

So wht will the syntax be if I want the fieldValue count of ID where Dept is Finance?

Please Help

Re: How to Retrieve values from a variable?

marcus_sommer — Thu, 21 Aug 2014 13:05:14 GMT

I think you will need a load for this:

t1:

Load count(distinct ID & Dept) as Count_IDDept Resident xyz where Dept = 'Fianance';

You could this use as field or write it per peek() in a variable.

- Marcus

Re: How to Retrieve values from a variable?

Fri, 22 Aug 2014 05:10:04 GMT

Hi Marcus, thanks for the reply it worked with the above expression but I want to put a condition on date field as well its showing error then..

below is my Script.

temp:

Load count(distinct ID & [Dept] & [Joining Date]) as Count_IDDept Resident MyTable where [Joining Date]>=weekstart(date(now()),-1) & [Dept] = 'Finance';

It says "Garbage after Statement

temp:

Load......"

Re: How to Retrieve values from a variable?

marcus_sommer — Fri, 22 Aug 2014 08:36:57 GMT

I think it's the "&" which meant a string-concat - you need a "and":

temp:

Load count(distinct ID & [Dept] & [Joining Date]) as Count_IDDept Resident MyTable where [Joining Date]>=weekstart(date(now()),-1) and [Dept] = 'Finance';

- Marcus