topic Re: need expression for following scenario in QlikView

need expression for following scenario

Tue, 19 May 2015 03:55:21 GMT

i have a scenario i want to display the rows which contain lead,opportunities,contacts=0

please find the following attachment

Re: need expression for following scenario

Tue, 19 May 2015 04:00:22 GMT

i need straight table like 2nd sheet in excel

Re: need expression for following scenario

senpradip007 — Tue, 19 May 2015 04:35:26 GMT

No 2nd sheet is there in the excel.

Re: need expression for following scenario

Tue, 19 May 2015 05:06:37 GMT

Re: need expression for following scenario

fashid — Tue, 19 May 2015 05:11:14 GMT

There is no second sheet friend. please check your attachment

Re: need expression for following scenario

Tue, 19 May 2015 07:51:57 GMT

sorry plz check this one

Re: need expression for following scenario

senpradip007 — Tue, 19 May 2015 08:47:43 GMT

Where the attachments?

Re: need expression for following scenario

Tue, 19 May 2015 09:47:25 GMT

sry once again olz find the below attachment

Re: need expression for following scenario

Tue, 19 May 2015 09:53:14 GMT

Hi,

Try this:

for count of activity id where lead,opportunities,contacts=0

=count({<response={0},oppty={0},lead={0}>}[activity id])

Thanks

khushboo

Re: need expression for following scenario

antoniotiman — Tue, 19 May 2015 10:20:10 GMT

Hi,

You can use calculated dimension as

If(response=0 and oppty=0 and lead=0,[activity id])

or Aggr(If(..........,[activity id]),[activity id]) if You need.

Regards,

Antonio

Re: need expression for following scenario

Tue, 19 May 2015 10:25:11 GMT

Hi Praveen,

you can try this:

=count({<response={0},oppty={0},lead={0}>}[activity id])

Ramya

Re: need expression for following scenario

Tue, 19 May 2015 10:55:30 GMT

Hi Praveen,

I think it is best done at the script level. Please see the attached script.

Thanks,