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

berryandcherry6 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Gysbert_Wassenaar — Wed, 18 May 2016 11:48:59 GMT

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

topic Re: selecting particular column values based on two column values in a single table in QlikView

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

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