Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor 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
rgvavihs
Valued Contributor

Re: Setanalysis issue while taking count.

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
Contributor II

Re: Setanalysis issue while taking count.

Hi,

Thanks for your reply

This gives me zero counts.

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

berryandcherry6
Contributor II

Re: Setanalysis issue while taking count.

Hi rgv rand,

Can you please look into my edited question.

Thanks,

Supriya

MVP
MVP

Re: Values not getting displayed in textbox

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

berryandcherry6
Contributor II

Re: Values not getting displayed in textbox

Hi sunny,

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

MVP
MVP

Re: Values not getting displayed in textbox

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

berryandcherry6
Contributor II

Re: Values not getting displayed in textbox

!Hi,

Thanks for your reply !

Please look at attached sample in original post

MVP
MVP

Re: Values not getting displayed in textbox

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
Contributor II

Re: Values not getting displayed in textbox

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.

Community Browser