Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor 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
Highlighted
MVP & Luminary
MVP & Luminary

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

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