topic Re: EXPRESSION PROBLEM in QlikView

EXPRESSION PROBLEM

adiarnon — Mon, 09 Jun 2014 10:23:48 GMT

hi,

I HAVE TWO TABLES:

Resource ID	Resource Name
1	A
2	B
3	C

DATE	Resource ID	AVAILEBLE HOURS	WORK HOURS
1.1.14	1	9	10
1.1.14	2	9	8
1.1.14	3	9	12
2.1.14	1	9	9
2.1.14	2	9	8

I WANT TO SHOW A NUMBER -

HOW MANY RESURCE HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

IN MY CASE - 2 :

1 - AVAILEBLE HOURS:18 ,WORK HOURS:19

3 - AVAILEBLE HOURS:9 ,WORK HOURS:12

WHAT EXPRESSION SHOULD I WRITE?

TNX.

Re: EXPRESSION PROBLEM

preminqlik — Mon, 09 Jun 2014 10:31:12 GMT

count({<ResourceID={'=[Working Hours]>[Available Hours]'}>}ResourceID)

for distinct

count(distinct {<ResourceID={'=[Working Hours]>[Available Hours]'}>}ResourceID)

Re: EXPRESSION PROBLEM

tresB — Mon, 09 Jun 2014 10:31:18 GMT

In a text box, try like: =Count({<[Resource ID]={"=Sum([AVAILABLE HOURS])<Sum([WORK HOUR]"}>} Distinct [Resource ID])

Re: EXPRESSION PROBLEM

Gysbert_Wassenaar — Mon, 09 Jun 2014 10:32:15 GMT

=count({<[Resource ID]={'=sum([AVAILEBLE HOURS])<sum([WORK HOURS])'}>}DISTINCT [Resource ID])

Re: EXPRESSION PROBLEM

tresB — Mon, 09 Jun 2014 10:32:38 GMT

Prem, you missed the aggregation. Isn't it?

Re: EXPRESSION PROBLEM

swuehl — Mon, 09 Jun 2014 10:33:17 GMT

Try in a text box:

=count({<[Resource ID] = {"=sum([WORK HOURS]) > sum([AVAILEBLE HOURS])"}>} distinct [Resource ID])

Re: EXPRESSION PROBLEM

Mon, 09 Jun 2014 11:15:13 GMT

Use this,

Count(Distinct Aggr(sum([WORK HOURS])>sum([AVAILABLE HOURS],[Resource ID]))

Regards,

Prabhu

Re: EXPRESSION PROBLEM

adiarnon — Tue, 10 Jun 2014 08:02:09 GMT

hi,

TNX for all the answars.

iits working!!!!!!!!!!!!

BUT,

i have a Another challenge:

i want that when i click on that text box it will choose all the resource that HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

how can i do that????

Re: EXPRESSION PROBLEM

tresB — Tue, 10 Jun 2014 08:11:59 GMT

adi arnon wrote:

....

i want that when i click on that text box it will choose all ....

You mean select ? You have to use a trigger for that. Try to share your a sample qvw.

Re: EXPRESSION PROBLEM

adiarnon — Tue, 10 Jun 2014 08:37:18 GMT

Unfortunately i cant share.

i mean that it will select in the field 'Resource ID' all of those who HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

hope its more clear

Re: EXPRESSION PROBLEM

tresB — Tue, 10 Jun 2014 08:43:53 GMT

See : Preparing examples for Upload - Reduction and D... | Qlik Community