topic Re: Set Analysis Issue with Calculation in QlikView

Set Analysis Issue with Calculation

Mon, 27 Apr 2015 13:26:41 GMT

I have a calculation that needs filtered using set analysis when its displayed in a table box. The calculation is created in the Load Script:

A-B = 'Days Old'

How can I setup the set analysis syntax correctly in the table box expression?

This is not working:

{$<[Group] = {"Int", "Stone"}>}[Days Old]

Re: Set Analysis Issue with Calculation

sunny_talwar — Mon, 27 Apr 2015 13:33:19 GMT

table box doesn't allow for expressions. Are you talking about a straight table expression?

Best,

Sunny

Re: Set Analysis Issue with Calculation

ankitaag — Mon, 27 Apr 2015 13:39:49 GMT

Kindly write the full expression

Re: Set Analysis Issue with Calculation

Mon, 27 Apr 2015 13:43:03 GMT

Yes I'm talking about a straight table

Re: Set Analysis Issue with Calculation

Mon, 27 Apr 2015 13:43:35 GMT

I included the expression. Its simply the field pulled into the expression. perhaps this isn't the correct way to do this.

{$<[Group] = {"Int", "Stone"}>}[Days Old]

Re: Set Analysis Issue with Calculation

sunny_talwar — Mon, 27 Apr 2015 13:45:03 GMT

May be a Sum/Count/Min/Max({$<[Group] = {"Int", "Stone"}>}[Days Old])

Re: Set Analysis Issue with Calculation

Anonymous — Mon, 27 Apr 2015 13:46:25 GMT

Set analysis works only in aggregation expressions, e.g. sum(), count(), max(), etc. In your case it is probably
avg({$<[Group] = {'Int', 'Stone'}>}[Days Old])
or
only({$<[Group] = {'Int', 'Stone'}>}[Days Old])

But this is just my guess.
And, as sunindia pointed out, you can't do it in a table box.