Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master 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
preminqlik
Specialist II
Specialist II

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
preminqlik
Specialist II
Specialist II

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

tamilarasu
Champion
Champion

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!!

preminqlik
Specialist II
Specialist II

technically we call it is inheriting