Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

[ASK] create date set analysis

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

1 Solution

Accepted Solutions
Partner
Partner

Re: [ASK] create date set analysis

try this one

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

View solution in original post

3 Replies
Partner
Partner

Re: [ASK] create date set analysis

try this one

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

View solution in original post

Not applicable

Re: [ASK] create date set analysis

many thx Liron..

btw what p() function is?

this solution is really helping me a lot

Partner
Partner

Re: [ASK] create date set analysis

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