Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bthatcher
New Contributor

Set analysis problem

I'm trying to create a chart that only brings in a value for certain varaible, I've created the expression below

Sum({$< ACCAccount ={12170,12340,12350,13910,"2A600","2AB00"}>} GLBal.YTDActual)

This does give me the information but it is split by each ACCAaccount, what I need is one total for all 7 codes

1 Solution

Accepted Solutions
kouroshkarimi
Contributor III

Re: Set analysis problem

If you want one total for all 6 codes, then I would remove the ACCAccount field as a dimension.

9 Replies
MVP
MVP

Re: Set analysis problem

Try the TOTAL qualifier:

Sum({$< ACCAccount ={12170,12340,12350,13910,"2A600","2AB00"}>} TOTAL GLBal.YTDActual)

bthatcher
New Contributor

Re: Set analysis problem

No that didn't work, seemed to bring through the tatal for all the ACCAaccount not just the 7 I'm interested in.

sujeetsingh
Honored Contributor III

Re: Set analysis problem

Hi,

one thing i noticed is that you are always asking for 7 codes but in set analysis there are only 6 codes

And please come with a complete briefing.

Thanks

bthatcher
New Contributor

Re: Set analysis problem

Sorry only 6 codes, I miss counted

MVP
MVP

Re: Set analysis problem

It should return the total only for the set of values, but it will display this total for all dimension values, not only for the values in your set.

If you are going to use another aggregation in this expression with the same set, e.g. to calculate a percentage, this should overcome the issue:

= Sum({$< ACCAccount ={12170,12340,12350,13910,'2A600','2AB00'}>} GLBal.YTDActual) /

Sum({$< ACCAccount ={12170,12340,12350,13910,'2A600','2AB00'}>} TOTAL GLBal.YTDActual)

Or just define that you only want to see the total for the dimension values in question:

if( match(ACCAcount,'12170','12340','12350','13910','2A600','2AB00'), Sum({$< ACCAccount ={12170,12340,12350,13910,'2A600','2AB00'}>} TOTAL GLBal.YTDActual) )

kouroshkarimi
Contributor III

Re: Set analysis problem

"but it is split by each ACCAaccount"

What is the dimension in the chart?

bthatcher
New Contributor

Re: Set analysis problem

The two dimesions are ACCAaccount and Period

kouroshkarimi
Contributor III

Re: Set analysis problem

If you want one total for all 6 codes, then I would remove the ACCAccount field as a dimension.

bthatcher
New Contributor

Re: Set analysis problem

Thnaks resolved my problem