topic Re: Need Help to get Expression in QlikView

Need Help to get Expression

Thu, 18 Jun 2015 14:37:10 GMT

Hi All,

I have Office , Start date, and calendar date , now I want to compare Start Date with Calendar date,

if Start date equals to the the calendar date then I need sum(office) by Year wise.

can any one help to get the expression.

for sample data PFA.

Regards

John

Re: Need Help to get Expression

ramoncova06 — Thu, 18 Jun 2015 14:42:53 GMT

I assume your requirement is more that just what you uploaded but, this you can use "p" for this

sum({<StartDate =p(Date)>}office)

Re: Need Help to get Expression

Thu, 18 Jun 2015 14:59:17 GMT

Hi Ramon Covarrubias.

Thanks. it works fine.

can you please explain what is the use of P(), E() functions in which situation we can use these two. functions.

is there any Performance issues with these two functions, or else any Performance improvements.

Regards

John

Re: Need Help to get Expression

ramoncova06 — Thu, 18 Jun 2015 15:22:25 GMT

in set analysis QV normally does not like to compare arrays of data, with the exception of manually defining the values e.g. date = {'2015-01-01','2015-02-01'} or by using P and E, that is normally used when your list is too big manually add

performance wise there is not really an issue unless both fields being compared have millions of rows

Re: Need Help to get Expression

Thu, 18 Jun 2015 15:39:59 GMT

can you please explain me what is the meaning of

today(1)

count(1)

count(total)

Regards

John

Re: Need Help to get Expression

ramoncova06 — Thu, 18 Jun 2015 16:10:06 GMT

today(1) is the equal to you current system time
I assume is count({1} field) this is to ignore all selections
count(total), this will give you the total of the expression, based on you current selections,
- let say you have the following data

Field	Metric
A	1
B	1
C	1

if you do a sum(Metric) using the field as your dimension you will get 1 per each, though if you use sum(total Metric) you will get 3 on each line