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: 
vishalgoud
Creator III
Creator III

urgent help required in set analysis expression..?

Hi Team ,

we have to restrict every chart to avoid the RG Group of MT...

so am adding the below set condistion in all the expressions to avoid it, but am in confusion how to add the same in below expression,

please help me.

=SUM(SMSVolume) / SUM(total <Month> SMSVolume)  

How to add below set condition in above expression please help me... Thank you.
{<RG_GROUP =- {"MT *"}>}

in numerator we can add easily but denominator part am getting confused....

12 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Maybe:

=SUM({<RG_GROUP =- {"MT *"}>}SMSVolume) / SUM(total <Month> {<RG_GROUP =- {"MT *"}>}SMSVolume)


Saludos

Anil_Babu_Samineni

Perhaps this?

=SUM({<RG_GROUP -= {"MT *"}>} SMSVolume) / SUM({<RG_GROUP -= {"MT *"}>} total <Month> SMSVolume)  

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vishalgoud
Creator III
Creator III
Author

Thanks for the Quick reply,

SUM(total <Month> {<RG_GROUP =- {"MT *"}>}SMSVolume) - in this denominator part is this indicates <Month>

even i tried the same and its not showing any expression error. but was just thinking we have to include this month in the set expression or what ..

earlier the expression was =SUM(SMSVolume) / SUM(total <Month> SMSVolume)   so what he is achieving from denominator part...

vishalgoud
Creator III
Creator III
Author

thanks for the quick help Anil,

what is this part indicates  <Month> from the below expression.

=SUM({<RG_GROUP -= {"MT *"}>} SMSVolume) / SUM({<RG_GROUP -= {"MT *"}>} total <Month> SMSVolume)

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Now i don´t understand your question.

Do you have a sample app to explain your request?

Saludos.

Anil_Babu_Samineni

SMSVolume will SUM the value of based on TOTAL Month field. For example

Data set is like below

Load * Inline [

Month, SMSVolume

Jan, 100

Jan, 200

Feb, 300

Feb, 100

];

And measure is this?

Sum(TOTAL <Month> SMSVolume) will return


result:

Jan, 300

Feb, 400

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vishsaggi
Champion III
Champion III

This means you are aggregating Sum(SMSVolume) by Month. And the TOTAL qualifier here respects the current selections on Month field. If you do no select any it will sum the volume for all months.

vishalgoud
Creator III
Creator III
Author

Thanks again , while am adding the same to other expression am getting an error in expression msg.

Can you please guide me what is worng in this below expression. it saying error in expression.

=num(MAX(
aggr(sum({<Month={"$(vLastMonth)"},REVENUE_GROUP =- {"MT *"}>}DataVolume),MSISDN)
),'#,##0')

vishalgoud
Creator III
Creator III
Author

=num(MAX(
aggr(sum({<Month={"$(vLastMonth)"},REVENUE_GROUP  -= {"MT *"}>}DataVolume),MSISDN)
),'#,##0')

i just changed the underliened part , i kept '- ' sign in front of = instead of keeping it after the equal sign... hope it will not change the meaning of my expression...