topic Re: intersection, set analysis in QlikView

intersection, set analysis

Tue, 16 Feb 2016 13:28:57 GMT

hi,

Senario:

I have year filter in app. I have a chart in which expressions I have coded as follows:

count({<Year={"$(=GetFieldSelections(Year))"} >}id)

.Problem:

if any selection is made in year filter which is in app(outside the chart), then the expression is fine. else it shows nothing as year will get assigned to null. But it should get assigned to *

is there any way to write using set intersection or any way without using if block in side chart?

Re: intersection, set analysis

sunny_talwar — Tue, 16 Feb 2016 13:30:27 GMT

Try this:

Count({<Year=p(Year)>}id)

UPDATE: I don't understand why do you even need it? Is Count(id) not working the same way?

Re: intersection, set analysis

swuehl — Tue, 16 Feb 2016 13:30:42 GMT

If you want Year just to follow the possible values of the Year list box, just remove the Set Expression:

=Count( id)

Re: intersection, set analysis

Mark_Little — Tue, 16 Feb 2016 13:38:48 GMT

Hi,

what is it your trying to do with the set analysis?

As the above statements say, Count(id) would be what you want, as it will count everything until selections are made

Your set analysis is saying show me the count of id, where the they match the selections of year list. Thus why null when nothing is selected.

Mark

Re: intersection, set analysis

Tue, 16 Feb 2016 13:40:39 GMT

The problem is year field in left side of '=' is different from that of in right side.

both belongs to different tables and I have to fetch year selected from outside chart and assign to another year field in side the chart(both year fields have different data)

Year={"$(=GetFieldSelections(Year)

Re: intersection, set analysis

Tue, 16 Feb 2016 13:40:46 GMT

The problem is year field in left side of '=' is different from that of in right side.

both belongs to different tables and I have to fetch year selected from outside chart and assign to another year field in side the chart(both year fields have different data)

Year={"$(=GetFieldSelections(Year)

Re: intersection, set analysis

Tue, 16 Feb 2016 13:41:02 GMT

The problem is year field in left side of '=' is different from that of in right side.

both belongs to different tables and I have to fetch year selected from outside chart and assign to another year field in side the chart(both year fields have different data)

Year={"$(=GetFieldSelections(Year)

Re: intersection, set analysis

sunny_talwar — Tue, 16 Feb 2016 13:43:31 GMT

Then may be this:

Count({<YearField1=p(YearField2)>}id)

Re: intersection, set analysis

Mark_Little — Tue, 16 Feb 2016 13:45:05 GMT

Hi,

So i think you have an issue more with the data model, I would be looking to associate the two date fields in a link table or conical calendar.

Canonical Date

Mark

Re: intersection, set analysis

Colin-Albert — Tue, 16 Feb 2016 13:47:24 GMT

If both fields have the same name (Year) they are the same data.

For them to be different they must have different names.

Have a look at your data model.

Re: intersection, set analysis

swuehl — Tue, 16 Feb 2016 13:54:12 GMT

Maybe like

=count({<Year1 = {"$(=If(GetSelectedCount(Year2), Concat(DISTINCT Year2, ','), '*' ))"} >} id)

[

If your Year2 value set is smaller than Year1 set, but you want all Year1 values in case of no Year2 selection.

Otherwise, the p() function as shown by Sunny should do it, too.

]

Re: intersection, set analysis

Tue, 16 Feb 2016 14:02:58 GMT

yes, fields are different say as below:

Yearpole={"$(=GetFieldSelections(Year)

yearpole is field and year is another field.

year is filter outside the chart whose selected value must be assigned to yearpole.

if no selection is made for year it is taking null. but it should take * i.e . all values. can u tell me the way without using if block as it increases load.

Re: intersection, set analysis

Tue, 16 Feb 2016 14:04:09 GMT

fields are different say as below:

Yearpole={"$(=GetFieldSelections(Year)

yearpole is field and year is another field.

year is filter outside the chart whose selected value must be assigned to yearpole.

if no selection is made for year it is taking null. but it should take * i.e . all values. can u tell me the way without using if block as it increases load.