topic Re: '::' in set analysis in QlikView

'::' in set analysis

qlikviewwizard — Mon, 19 Oct 2015 02:36:38 GMT

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.

Re: '::' in set analysis

preminqlik — Mon, 19 Oct 2015 02:46:34 GMT

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

Re: '::' in set analysis

tamilarasu — Mon, 19 Oct 2015 02:53:16 GMT

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

Re: '::' in set analysis

preminqlik — Mon, 19 Oct 2015 02:55:52 GMT

technically we call it is inheriting