topic Re: [ASK] create date set analysis in QlikView

[ASK] create date set analysis

Wed, 30 Apr 2014 03:22:01 GMT

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 — Wed, 30 Apr 2014 03:27:19 GMT

try this one

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

Wed, 30 Apr 2014 04:02:34 GMT

many thx Liron..

btw what p() function is?

this solution is really helping me a lot

lironbaram — Wed, 30 Apr 2014 06:09:25 GMT

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