Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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!!
technically we call it is inheriting