Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
qlikviewwizard
Honored Contributor II

'::' in set analysis

Hi All,

This is one of the expression in Whats New in Qlikview 11.

sum({[Group 1]<Region = $::Region, [Sales Rep] = $::[Sales Rep], Path = $::Path, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)

What is the purpose of this :: Please explain.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
preminqlik
Valued Contributor II

Re: '::' in set analysis

in your expression "Group1" is an Alternate State, means all fields are independent on Current Selections.

and for that particular expression. all fields are now dependent on "Group 1" state Fields.

Hence by Giving "::" , you are assigning Current Field selections to the Alternate Group Expressions.

@premhas

View solution in original post

3 Replies
Highlighted
preminqlik
Valued Contributor II

Re: '::' in set analysis

in your expression "Group1" is an Alternate State, means all fields are independent on Current Selections.

and for that particular expression. all fields are now dependent on "Group 1" state Fields.

Hence by Giving "::" , you are assigning Current Field selections to the Alternate Group Expressions.

@premhas

View solution in original post

Highlighted

Re: '::' in set analysis

Hi Arjun,

I used this kind of expressions when I tried to use alternate state. Here, :: means Group1 (alternate state) region field is equating with default state region values.

$::Region refers to the selection you’ve made in the Region field in the $state.


Check alternate state threads for more understanding!!

Highlighted
preminqlik
Valued Contributor II

Re: '::' in set analysis

technically we call it is inheriting