Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView 11 Set Analysis disregards my selection

Hi.

I am attempting to use Set Analysis to compare two data series over a certain time period. The first data series looks at all records in my data set over a certain month. I created a line chart where I look at that information and make the necessary date range selections in a multi-box. It looks like this:

Then I attempt to add the data series that I want to compare using set analysis I wanted to limit the data to a certain class so I used a formula similar to this:

                    sum({$<Class = {'Tier 1'}>} NumberIamMeasuring)

I was under the impression that the use of the "$" identifier would keep my current selections in tact. But when I do this my selections are disregarded and my chart turns into this:

I have been referencing the document I have attached and I can't seem to figure out what kind of mistake I am making.

Any help would be very appreciated.

Thanks.

6 Replies
p_verkooijen
Partner - Specialist
Partner - Specialist

Nathan,

Your SetAnalysis statement sets the Class to 'Tier 1' on top of the current selection state $.

$ - Represents the records of the current selection

If you would like to compare the first SUM(NumberIamMeasuring) with sum({$<Class = {'Tier 1'}>} NumberIamMeasuring) you'll have to create 2 expressions.

Not applicable
Author

I'm sorry, I should have specified. I do have both expressions on there. It's just that after adding the second expression (the one with the set analysis), the chart changes and my date selections are ignored.

p_verkooijen
Partner - Specialist
Partner - Specialist

Based on your screenshots I can only see the difference in year.

Could you upload a small example app ?

Not applicable
Author

I could work on setting up a small example app but it might take me a bit.

But the problem is the difference in the year. I need my month and day selections to stay the same when I apply that set analysis expression.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I looks like you have checked on "continuous" on the Axes tab? Does it work if you uncheck that?

-Rob

Not applicable
Author

Unfortunately no. Continuous is actually not checked. I tried it again after checking and unchecking it and there were no changes.