Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

Values not getting displayed in textbox

Hi all,

I am trying to get  current_campaign_id  based on batch_meta_data_id  and current_start_date.But here i am not able to get anyvalues when i put this expression inside textbox.

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

even i tried on this

Concat({current_campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})

>} current_campaign_id, ', ')


but no luck

Please help me on this.

Thanks,

Supriya

23 Replies
Anonymous
Not applicable

Try this

Count({$<DateType= {'completion'}, final_test_status={'passed'},

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

>} invitation_id)

berryandcherry6
Creator II
Creator II
Author

Hi,

Thanks for your reply

This gives me zero counts.

I think   '>}'  should be removed in your answer.

berryandcherry6
Creator II
Creator II
Author

Hi rgv rand,

Can you please look into my edited question.

Thanks,

Supriya

sunny_talwar

Have you checked if you even have data for the those combination in your database?

berryandcherry6
Creator II
Creator II
Author

Hi sunny,

yes,i have checked i have values for those combination.

sunny_talwar

Will you be able to provide a sample so that we can take a look at the issue?

berryandcherry6
Creator II
Creator II
Author

!Hi,

Thanks for your reply !

Please look at attached sample in original post

sunny_talwar

I don't see any current_campaign_id where date is 5-17-2016 and batch_meta_data_id = 23 or 24

Capture.PNG

I have a feeling that you are not working with the incorrect date here? Are you sure you want this

=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY')

or another date which is not based on Today(), but based on current_start_date

berryandcherry6
Creator II
Creator II
Author

Hi,

Don't take campaign_start_date,take current_start_date or start_date in CAMPAIGN table.

I am comparing current_start_date in CAMPAIGN table with =Date(WeekStart(Today()) + 1, 'MM-DD-YYYY').

Because start date(or renamed as  current_start_date ) indicates start date of campaign.

Here i am trying to get campaign_id  which started  this week(as every campaign starts on tuesday of every week ,i am comparing weekstart with start date in CAMPAIGN table) and which are based on batches 23 and 24.