topic Set analysis with $1 in QlikView

Set analysis with $1

Thu, 14 May 2009 20:00:04 GMT

I want to use $1 on one dimension.

This works

Sum({$< Aktiv = , Sammenlignelig = , Kjede = , Periode = >} Sales)

Should it be possible to write something like

Sum({$1< Marked >} Sales)

Regards

Jerrik

Set analysis with $1

manishkumar75 — Thu, 14 May 2009 20:18:32 GMT

Hi,

$1 represents the previous selection, i.e. equivalent to pressing the Back button.

Sum ({$1} Sales) , returns sales for the previous selection.

- Manish

Set analysis with $1

johnw — Fri, 15 May 2009 02:14:32 GMT

While I have no idea how you would use it, and while the format is very ugly, I have come up with a way to say that you want the current selections for all fields except for a specific field, for which you want the previous selection. In the example file, I have four fields. Here's how I do what I think you want:

sum({$1<Type ={$(=concat(distinct Type ,','))}

Class={$(=concat(distinct Class,','))}

Sales={$(=concat(distinct Sales,','))}>}Sales)

Probably not a good idea in practice, but it was an interesting exercise.

Set analysis with $1

Fri, 15 May 2009 16:37:45 GMT

Hi John,

Thx for trying. The code doesnt give me the answer I was looking for.

I have modified your excampel a bit, to explain.

In text I want to have current selection for Type and Class, but previous selection for Marked. Like Sum( {$1}<Marked> <{$]Type,Class>}Sales) whitch does not work, and of course without having to type all $-Fields.