Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alina_qlik
Contributor III
Contributor III

Set expression to recur a value after ignoring a dimension

Hello Fellas ,

I am trying to keep up with set expression . But for this view i am just not good enough .
Please guide me to right expression to attain a view . 

SOURE :

CompanyAreaProfitLossA1A2A3A4Glist
BoeingAREA13727ABCEFGGGGIJK 
BoeingAREA24332     
BoeingAREA35125     
BoeingAREA48233     
BoeingAREA56826     
Boeing       28
MigAREA17734LMNOPQRSTUVW 
MigAREA23329     
MigAREA39424     
MigAREA49623     
MigAREA53033     
Mig 3340    75

 

Resulting 

CompanyAreaProfitLossOUTPUTGlist
BoeingAREA13727ABC28
BoeingAREA24332EFG28
BoeingAREA35125GGG28
BoeingAREA48233IJK28
BoeingAREA56826 28
MigAREA17734LMN75
MigAREA23329OPQ75
MigAREA39424RST75
MigAREA49623UVW75
MigAREA53033 75


OUTPUT expression which i tried  but in vain 

If(Area='AREA1',Concat( {1<Area=,Company=p(Company)>}DISTINCT A1),If(Area='AREA2',
Concat( {1<Area=,Company=p(Company)>}DISTINCT A2),If(Area='AREA3',
Concat( {1<Area=,Company=p(Company)>}DISTINCT A3),If(Area='AREA4',
Concat( {1<Area=,Company=p(Company)>}DISTINCT A4))
)))


Glist expression which i tried  

sum({<Area=>}Glist)


Help in correcting the expression . 


Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You were pretty close. I think you were misunderstanding the meaning of the set {1}. {1} ignores selections, but it does not ignore the dimension.  What you want is TOTAL. For Glist

sum(TOTAL<Company>Glist)

And for OUTPUT you could modify your If(), or use Pick(Match()) which is an alternative form. 

pick(
Match(Area, 'AREA1', 'AREA2', 'AREA3', 'AREA4')
,concat(TOTAL <Company>A1)
,concat(TOTAL <Company>A2)
,concat(TOTAL <Company>A3)
,concat(TOTAL <Company>A4)

)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You were pretty close. I think you were misunderstanding the meaning of the set {1}. {1} ignores selections, but it does not ignore the dimension.  What you want is TOTAL. For Glist

sum(TOTAL<Company>Glist)

And for OUTPUT you could modify your If(), or use Pick(Match()) which is an alternative form. 

pick(
Match(Area, 'AREA1', 'AREA2', 'AREA3', 'AREA4')
,concat(TOTAL <Company>A1)
,concat(TOTAL <Company>A2)
,concat(TOTAL <Company>A3)
,concat(TOTAL <Company>A4)

)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

alina_qlik
Contributor III
Contributor III
Author

Thank You for the help . I think among contemporaries  Qlik community is best and fast to suggestion .

If i have understood right , sum(TOTAL<Company>Glist) ---- means sum of glist after ignoring all dimension but Company . 

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, your understanding is correct.

-Rob