topic Re: expression in set analysis ... urgent!!!! in QlikView

expression in set analysis ... urgent!!!!

Mon, 23 Sep 2013 05:32:36 GMT

Hi all,

This is my current expression=COUNT(if(ENTITY<>NULL() AND LEN(TRIM(ENTITY))>=1,INT TRD ID)).... I need to acheive the same in set analysis.

Thanks in advance

Re: expression in set analysis ... urgent!!!!

jagan — Mon, 23 Sep 2013 09:16:54 GMT

Hi,

Try like this

=COUNT({<ENTITY={'*'}>} [INT TRD ID])

Hope this helps you.

Regards,

Jagan.

Re: expression in set analysis ... urgent!!!!

simondachstr — Mon, 23 Sep 2013 09:22:53 GMT

Or alternatively, depending on what you need to display, the intersection of your current selection and your set analysis:

=COUNT({<ENTITY*={'*'}>} [INT TRD ID])

Re: expression in set analysis ... urgent!!!!

Mon, 23 Sep 2013 09:23:14 GMT

Hi Jagan Mohan,

I need to create one straight table or pivot table. I need to get Sum(Amount) where ActualID=AccountID. for each individual employee. The dimension is EmployeeID. But this EmployeeID and Amount are from one table, whereas ActualID is from another table.

Could you help me how to write the expression please as it is urgent for me please

Thanks.

Re: expression in set analysis ... urgent!!!!

Mon, 23 Sep 2013 14:32:09 GMT

hi what * will do? Is it possible to convert my same expression in Set analysis.

thnanks

Re: expression in set analysis ... urgent!!!!

jagan — Mon, 23 Sep 2013 14:54:04 GMT

Hi,

Is it working? * will exclude all the null values.

=COUNT({<ENTITY={'*'}>} [INT TRD ID])

Regards,

Jagan.

Re: expression in set analysis ... urgent!!!!

Mon, 23 Sep 2013 15:06:03 GMT

COUNT({<ENTITY={'*'},ENTITY>} IF(LEN(TRIM(ENTITY))>1,[INT TRD ID]))

Re: expression in set analysis ... urgent!!!!

Mon, 23 Sep 2013 15:29:56 GMT

Hi jagan

But I want to exclude null value s

Thnx