topic Re: convert to set analysis in QlikView

convert to set analysis

Anonymous — Tue, 17 Feb 2015 10:09:24 GMT

can anybody convert this expression to set analysis??

if(if(WeekDay(row_date)='Mon',row_date-2,row_date-1),agentacdcalls)

Re: convert to set analysis

robert_mika — Tue, 17 Feb 2015 23:26:06 GMT

Could you post the data behind this task?

Re: convert to set analysis

sunny_talwar — Wed, 18 Feb 2015 02:44:22 GMT

I understand your first if statement here If(WeekDay(row_date) = 'Mon', row_date-2, row_date-1. But what exactly is your first if statement checking for??? If(If(WeekDay(row_date) = 'Mon', row_date-2, row_date-1) >=<???

Please clarify.

Best,

Re: convert to set analysis

Anonymous — Wed, 18 Feb 2015 09:06:08 GMT

actually am looking for previous day data, if Monday comes am getting Sunday data but instead of Sunday i need Friday data...

how can we write set analysis for above requirement??

Re: convert to set analysis

AbhijitBansode — Wed, 18 Feb 2015 10:56:04 GMT

assign a numeric counter to your date column say.PeriodID

Now, if(WeekDay(row_date)='Mon',

sum({"$(=max(PeriodID)-2)"}MetricField),

sum({"$(=max(PeriodID))"}MetricField),

)

Re: convert to set analysis

timanshu — Wed, 18 Feb 2015 18:15:34 GMT

But why you want this expression in set analysis, as if that expression is working for you ??

Re: convert to set analysis

Anonymous — Thu, 19 Feb 2015 10:36:14 GMT

Unless i select the date filter i want display default last working date data...

Re: convert to set analysis

timanshu — Thu, 19 Feb 2015 10:56:19 GMT

I think you can sort the Data by Date and use previous function to get the last working day , as previous record will be the last working day. And you can exclude the functionality on any Date Selection.

Can you attach your app , So that I can apply functionality on that.