topic Set analysis - Date island in QlikView

Set analysis - Date island

Fri, 24 Jun 2011 11:11:12 GMT

Hi,

I have created one date island table.

i have one transaction table...

i loaded the date island table fields like year,month,Qtr in list boxes.

in transaction table i have transyear,transmonth,transQtr fields.

i need to show the sum(sales) by customerwise.

if i used the transyear,transmonth,transQtr in list boxes, then i can write sum(sales) in expression tab,Customer as Dimension.

but i need to use the date island table fields...

could anyone hepl me how to write the expression...

due to restrictions i cant upload the sample file...

Set analysis - Date island

stephencredmond — Fri, 24 Jun 2011 11:31:59 GMT

Hi,

Depending on what calculation you want it would look something like this:

Sum({$<Trans_Date=P({$} Island_Date)>} TransValue)

=> Total of values based on current selection in Data Island dates.

Sum({$<Trans_Date={"<=$(=Max(Island_Date))"}>} TransValue)

=> Total of all transactions up to an including the selected Island Date.

Regards,

Stephen

Set analysis - Date island

Fri, 24 Jun 2011 11:45:16 GMT

Hi Stephen,

thank you very much...

u solved my big problem....

i will enjoy the week end...

Set analysis - Date island

Fri, 24 Jun 2011 12:10:39 GMT

i need one more help...

i created one straight table by dimension as Customer

in expression i worte sum({<Month={Jan}>} sales) for jan,

sum({<Month={Feb}>}sales) for feb,

sum({<Month={Mar}>}sales) for Mar,

sum({<Qtr={Q1}>} for Q1,

sum({<Month={Apr}>}sales) for Apr,......

bcoz of the req i wrote separately for each month and Quarter....

if i select the month Apr then i need to show the value for only Apr month and Q2 remaining should be 0.

but in my case it shows the value for all the month...

could you help me....

Set analysis - Date island

stephencredmond — Fri, 24 Jun 2011 13:00:35 GMT

You could use an Intersection with the implicit operator:

Sum({<Month={'Feb'}*P()>} Sales)

Regards,

Stephen

Re: Set analysis - Date island

Thu, 04 Oct 2012 13:28:21 GMT

Hello,

I am trying to solve similar problem.

http://community.qlik.com/message/265898#265898

I would like to ask you, what "P" does mean?

Thank you!

Mirek