Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Differing in count values when condition from script loader is moved to front end.

Hi all,

I am trying to get counts of course completed value, whose campaign  starts in previous week  , final_test_status is passed and DateType = invitation.

I am getting correct value counts,when condition is put in script and passed those datas in front end.

But when i try putting all condition in front end i.e comparing last week dates to get campaign id , i get wrong count .

Please help me on this i have attached qvf file and i have to achieve this by putting condition in front end itself.

Regards,

Tags (1)
5 Replies
brijeshma
Contributor

Re: Differing in count values when condition from script loader is moved to front end.

Hi,

Your qvf is showing internal error ..

can you share another one.. Either can you confirm what the script are you using in script editor and expression

berryandcherry6
Contributor II

Re: Differing in count values when condition from script loader is moved to front end.

Hi,

Thanks for your reply

In script

  LOAD `campaign_id` as  campaignid,

`batch_meta_data_id`,

    date(floor(start_date),'MM-DD-YYYY') as current_start_date,

    `expiration_date`;

SQL SELECT

`batch_meta_data_id`,

`campaign_id`,

`start_date`,

`expiration_date`

FROM CAMPAIGN;

CurrentCampaignData:

Load

batch_meta_data_id,

campaignid as current_campaign_id

Resident CAMPAIGN

WHERE ( current_start_date = Date(weekstart (Num ( today() ),-1 ) +1)) and match(batch_meta_data_id ,'23','24');

and to get count i use in front end this,

count({$<DateType= {'completion'},final_test_status={'passed'},campaign_id = P(current_campaign_id)>} course_completed)


For above i get correct value, but instead of all this scripting of condition in loader ,if i directly place condition in front end i get wrong count


Used code in front end is


Count({$<final_test_status={'passed'}, campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today(),-1) + 1,  'MM-DD-YYYY'))"}>})>} course_completed)


for this i get wrong count.

brijeshma
Contributor

Re: Differing in count values when condition from script loader is moved to front end.

Hi,

Can u share Qvd for the same data.. and what the count are getting in Script and Expression

berryandcherry6
Contributor II

Re: Differing in count values when condition from script loader is moved to front end.

HI Brijesh ,

Please check the new attached qvf file.

i think you are loading data in script ,please dont load data over in script

brijeshma
Contributor

Re: Differing in count values when condition from script loader is moved to front end.

Hi Supriya

Sry, i am downloading the same.. But its give the same error..