Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Subsetting data WITHOUT selecting

Hello,

I'm new to Qlikview, and still wrapping my head around the syntax/logic of Qlickview expressions.   My data in cumulative, similar to the table given below, and I'm trying to make a series of charts out of it.  The first two charts are line charts showing trend lines for all days selected by the max/min of a slider bar.  The third chart is supposed to be a pie chart showing the distribution of "Type" AT THE MAX DEVELOPMENT DAY SELECTED.  So, if the slider selects days 2-4, the pie chart should sum(notices) where "Development Days" = 4.  This would provide the trend to a point, and then the distribution between "Type" at the end point. 

I've been trying

Sum(If(NumMax([Dev_days])=[Dev_days],[notices],0))

but the results still change based on the minimum. 

Development DaysTypeNotices
1

A

2
2A8
3A

11

4A14
5A17
1B3
2B7
3B12
4B16
5B21
6B24

Thank you in advance for your help!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Subsetting data WITHOUT selecting

Try a set expression:

sum({<[Dev_days] = {$(=max([Dev_days]))}>} [notices] )

2 Replies
MVP
MVP

Subsetting data WITHOUT selecting

Try a set expression:

sum({<[Dev_days] = {$(=max([Dev_days]))}>} [notices] )

Not applicable

Subsetting data WITHOUT selecting

Thank you!  That worked perfectly, and now I know there are things called "sets" in Qlikview to search in the future. 

Community Browser