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: 
Anku
Creator
Creator

Set Expression logic

Hi all, Please refer below snapshot;

Anku_0-1666589391971.png

Where it is direct, it's easy but to some names the values should be an output of calculation as shown above e.g., Name "C".

Note: all Names have their respective Keys which has some values ( which are itself a output from an expression). Also, only expression is required, script level changes not possible.

Thanks.

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

=Alt( sum({<Logic={'Direct'}>}Value) , sum({<Logic={'Num'}>}Value) / sum({<Logic={'Den'}>}Value)  )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

as below

 

=sum(value) / sum(TOTAL <Name> value)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anku
Creator
Creator
Author

Thanks for your response. 

Provided expression will divide each cell value with overall sum. 

However, here I am looking for an expression which can divide values against respective names having num and denom in logic column. 

Eg, Name "A" will show as 7681 (key is 1) however name "C" will be the out put of 7521/6920 ( key 45/67).

Thank you

vinieme12
Champion III
Champion III

=Alt( sum({<Logic={'Direct'}>}Value) , sum({<Logic={'Num'}>}Value) / sum({<Logic={'Den'}>}Value)  )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anku
Creator
Creator
Author

Thanks, Alt was not working hence IF used,

IF([COMPUTING LOGIC] = 'DIRECT',sum({<[COMPUTING LOGIC] ={'DIRECT'}>}VALUE),
NUM((sum({<[COMPUTING LOGIC]={'Num'}>}VALUE) / sum({<[COMPUTING LOGIC]={'Den'}>}VALUE)),'###0%' ))