topic Re: How to write expression in chart? in QlikView

How to write expression in chart?

Thu, 12 Mar 2015 10:58:31 GMT

Hi,

I have to write expression when

Progress <>'In', 'Out', 'Delete ' then count of ID

can anyone suggest me please.

Thanks.

sunny_talwar — Thu, 12 Mar 2015 11:00:25 GMT

Try something like this:

=Count({<Progress = e({<Progress = {'In', 'Out', 'Delete'}>})>} ID)

you might need a DISTINCT if you only want to count the unique instances.

HTH

Best,

amit_saini — Thu, 12 Mar 2015 11:03:02 GMT

Hi,

Try something similar:

count(distinct if(filedname<>0, UserID)

count(distinct if(UserID<>0, UserID)

count({$<UserID-= {'0'}>} distinct UserID)

Thanks,

MK_QSL — Thu, 12 Mar 2015 11:04:37 GMT

=COUNT({<Progress -= {'In','Out','Delete'}>}DISTINCT ID)

amit_saini — Thu, 12 Mar 2015 11:05:05 GMT

Try this:

count({$<Progress-= {'In', 'Out', 'Delete'}>} distinct ID)

Thanks,
AS

Thu, 12 Mar 2015 11:07:04 GMT

Thanks for all answers

mukesh24 — Thu, 12 Mar 2015 11:07:37 GMT

Hi,

=COUNT({<Progress -= {'In','Out','Delete'}>}DISTINCT ID)

=count(if(not wildmatch(Progress,'In','Out','Delete'),ID)

Regards,

Mukesh

Thu, 12 Mar 2015 11:21:23 GMT

Hi,

Try this.

=Count({$<FieldName = e({$<Progress = {'In', 'Out', 'Delete'}>})>} ID)