[ASK] create date set analysis

[#1]

Hallo QlikView User,

i have 3 table :

1. A (%KeyID, YearA, MonthA, WeekA)

2. B (%ItemCode, [PO Date], YearB, MonthB, WeekB)

3. LINK_TABLE (%KeyID, %ItemCode, YearLink, MonthLink, WeekLink)

on my dashboard for date selection are using YearA, MonthA, WeekA.

i have to create text with count([PO Date])

if i test it with date from B table, i have no problem.

but when i use date selection, which is from table A, the data shows no valid result.

and then i try to using set analysis :

=count( {1<YearB={"$(=max(YearA))"}>} [PO Date])

the results are good, if i only select YearA from date selection, and no effect when i select MonthA.

so i try another set analysis :

=count({1<YearB={"$(=max(YearA))"}>

*

<MonthB={"<=$(=max(MonthA))"}>

}

[PO Date])

but the result is uncorrect, the result is less than first set analysis for Year selection.

is there any idea to correct my set analysis?

many thx and sorry for my bad english

[lironbaram · Accepted solution]

try this one

count( {1<YearB=p(YearA),MonthB=p(MonthB),WeekB=p(WeekA)>} [PO Date])

[#3]

many thx Liron..

btw what p() function is?

this solution is really helping me a lot

[lironbaram]

p() means that you get all possible values from the field inside , YearA for example

there is another useful function which is e() you will get all the values exclude those that are in the field inside the function