topic Re: Urgent Need in QlikView

Urgent Need

Mahamed_Qlik — Thu, 27 Aug 2015 06:17:19 GMT

Hi Guys,

I have following field i need the count of CropCode starting with 'CS only.

For example : only CS001, CS002, CS003,CS004 so the count should be 4

CropCode
CS001
CS002
CS003
CS004
1001
1002

Kindly Help.

Re: Urgent Need

sasiparupudi1 — Thu, 27 Aug 2015 06:21:54 GMT

=Count({<CropCode={'CS*'}>}CropCode)

Re: Urgent Need

Mahamed_Qlik — Thu, 27 Aug 2015 06:23:24 GMT

Hi,

II tried but it is not working. showing count 0

Re: Urgent Need

qlikmsg4u — Thu, 27 Aug 2015 06:24:52 GMT

In script:

Load *,If(Left(CropCode,2)='CS',1,0) as CSCount;

Load * Inline [

CropCode

CS001

CS002

CS003

CS004

1001

1002];

in UI:

=Sum(If(Left(CropCode,2)='CS',1,0))

=Count({<CropCode={'CS*'}>}CropCode)

Re: Urgent Need

Mahamed_Qlik — Thu, 27 Aug 2015 06:28:53 GMT

Not working.

Re: Urgent Need

sasiparupudi1 — Thu, 27 Aug 2015 06:29:50 GMT

It shows 4 with the sample data.. how are you using it? may be can you share a sample?

Re: Urgent Need

qlikmsg4u — Thu, 27 Aug 2015 06:30:57 GMT

what do you mean by not working, it should work.what error you are getting

PFA

Re: Urgent Need

jagan — Thu, 27 Aug 2015 06:36:01 GMT

Hi,

This should work

=Count({<CropCode={'CS*'}>}CropCode)

If not try this

=Sum(Aggr(If(Upper(Left(CropCode, 2)) = 'CS', 1, 0), CropCode))

Hope this helps you.

Regards,

jagan.

Re: Urgent Need

Kushal_Chawda — Thu, 27 Aug 2015 06:43:23 GMT

create a flag in script,

if(wildmatch(lower(CropCode),'cs*',1,0) as CropCodeFlag

In front end use below expression

Count ({<CropCodeFlag={1}>}CropCode)

Re: Urgent Need

Mahamed_Qlik — Thu, 27 Aug 2015 07:00:55 GMT

Yes it works now..

There was an issue with the source db.

Thank you for your help.

Re: Urgent Need

Mahamed_Qlik — Thu, 27 Aug 2015 07:01:06 GMT

Yes it works now..

There was an issue with the source db.

Thank you for your help.

Re: Urgent Need

Mahamed_Qlik — Thu, 27 Aug 2015 07:01:23 GMT

Yes it works now..

There was an issue with the source db.

Thank you for your help.

Re: Urgent Need

jagan — Thu, 27 Aug 2015 07:14:43 GMT

Hi,

Please close this thread if you got the answer, it helps others in finding the answers.

Regards,

Jagan.