Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

selecting particular column values based on two column values in a single table

Hi all,

CurrentCampaignData:

Load

Batch_ID,

Campaign_ID as Current_Campaign_ID

Resident CAMPAIGN Where (current_start_date = Date(weekstart(Num(today()))+1));

I have created a table called CurrentCampaignData ,now i want to put expression for this so that i could retrieve Current_Campaign_ID based on Batch_ID and  current_start_date = Date(weekstart(Num(today()))+1).

i am using below expression but getting invalid expresion.

if((Batch_ID = {23,24} and current_start_date = Date(weekstart(Num(today()))+1)),Current_Campaign_ID)

or  is it possible to fetch datas  or is there other way?Any suggestion are welcomed

Please help me in this regard

Thanks,

Supriya

1 Reply
Gysbert_Wassenaar

Please don't clutter this site with duplicate discussions: expression for getting Campaign_id based on batch_id and date


talk is cheap, supply exceeds demand