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
sunny_talwar

Try this:

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

>} current_campaign_id, ', ')

Capture.PNG

berryandcherry6
Creator II
Creator II
Author

Hi Sunny,

Putting this in set analysis expression,its giving me zero count .

i have modified expresion to  below to pass it to set analysis.()

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

>} campaignid, chr(39)& ',' &chr(39) )& chr(39))

Whole Expression becomes

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

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

>} campaignid, chr(39)& ',' &chr(39) )& chr(39))

>} course_completed)

sunny_talwar

Is 14 the number you are looking to get?

Try this:

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

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


Capture.PNG

berryandcherry6
Creator II
Creator II
Author

HI,

No,this as to give count as 1.This result can be seen when we filter in table according to condition.

In count expression it gives count of whole campaign course completed count present in batches 23 and 24.Since count remains same with date condition and without it.

Regards

sunny_talwar

May be this:

Count(DISTINCT {$<DateType= {'completion'}, final_test_status={'passed'}, batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"},

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

berryandcherry6
Creator II
Creator II
Author

Hi,

I am not getting counts correctly.I have to get 13 as count. I think below equation is not fetching required campaign id,to get correct counts.

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

Please help me on this.

Regards,

Supriya

sunny_talwar

But in your previous post, you mentioned you wanted to get a 1? Now how did the count change to 13?

berryandcherry6
Creator II
Creator II
Author

Hi,

That was wrong count as i was on assumption that count got based on filtered values in table should be the count.

13, This count is from server db,even if i put above equation in server it gives me same count as 1.


This below condition just have to fetch required campaign ids,to expression,may it is not fetching those id's


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

sunny_talwar

Based on the application attached it was giving us 4 campaignid (102, 103, 104 and 105). Do you see anything wrong with them? I mean should there be another one or is there one which should not have been there?

berryandcherry6
Creator II
Creator II
Author

Hi,

No they are perfectly right,That logic working well to get campaign_id

But issue is in count.