topic Re: Set Analysis in QlikView

Set Analysis

Tue, 07 Jun 2016 10:28:04 GMT

Hello All, i need to write a set analysis expression. for when sign_flag = 1 and (orderdate - shipmentdate) > 0 then show (orderdate - shipmentdate) i tried writing something like =if((orderdate - shipmentdate))> 0 and count({}(orderdate - shipmentdate)) but it doesnt work, please i need your help urgently. Thanks & Regards, Jaya

Re: Set Analysis

Kushal_Chawda — Tue, 07 Jun 2016 12:01:07 GMT

=count({<sign_flag ={1},OrderDate={"=OrderDate-shipmentdate>0"}>}OrderID)

Re: Set Analysis

sunny_talwar — Tue, 07 Jun 2016 12:02:36 GMT

May be like this:

If(orderdate - shipmentdate > 0, Sum({<sign_flag = {1}>} orderdate - shipmentdate)

If(Only({<sign_flag = {1}>} orderdate - shipmentdate) > 0, Sum({<sign_flag = {1}>} orderdate - shipmentdate)

Re: Set Analysis

Wed, 08 Jun 2016 07:09:40 GMT

thanks Sunny and kushal.

Some how the expression you gave didnt work in my application.

i tried this sum({<sign_flag = {'1'}>} aggr(((order_startdate - productdate)),order_id)) in the pivot table but

still i dont get the desired data..

so i want the days differnce of the productdate is before the order date and want those days.

for example if the productdate is 01.05.2016 and the order_startdate is 06.05.2016..

Re: Set Analysis

Wed, 08 Jun 2016 08:01:15 GMT

please ignore my previous message.

the below expression works

sum({<sign_flag = {'1'}>} Aggr(((order_startdate - product_startdate)),apt_id))

now i need to add the condition (product_startdate < order_startdate) in the above expression.

how do i add this to the expression.

please help me with this

Thanks & Regards,

Jaya

Re: Set Analysis

sunny_talwar — Wed, 08 Jun 2016 09:50:04 GMT

May be this:

Sum({<sign_flag = {'1'}>} Aggr(If(product_startdate < order_startdate, order_startdate - product_startdate),apt_id))