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: 
Anonymous
Not applicable

Inputsum with Set Modifier

Greetings,

I am trying to add a set modifier into to the following:

=InputSum(ADD_AMOUNT,'*')

to get:

=InputSum(ADD_AMOUNT,'*' {<Account = 'Asset'>})

However i get a 'Error in expression' as soon as i add it to the previous - already working inputsum

I'm afraid there is a syntax error that i cant seem to grasp.

I have tried looking online for examples but failed

Any thoughts?

Thank you

1 Solution

Accepted Solutions
kusumanchir
Creator
Creator

Hi Byran,

Please try this,

=InputSum({<Account = 'Asset'>}ADD_AMOUNT,'*' )


Regards,

Rasly.K

View solution in original post

6 Replies
kusumanchir
Creator
Creator

Hi Byran,

Please try this,

=InputSum({<Account = 'Asset'>}ADD_AMOUNT,'*' )


Regards,

Rasly.K

kusumanchir
Creator
Creator

Hi Byran,

Please find the sample attached with set analysis expression.

-Rasly.K

Anonymous
Not applicable
Author

Hi,

Thank you for that.

One more question, is it possible to put an IF statement in the inputsum. I need some sort of workaround to prevent the user from putting negative values for example

Thanks

kusumanchir
Creator
Creator

Hi Byran,

Do you mean to say, display only the sum of positive values using inputsum() or not to allow users to input negative values ?

-Rasly.K

kusumanchir
Creator
Creator

Hi Byran,

Please find the modified sample app.

Created a chart with the name 'To exlcude -ve values'.

Let me know if it meets your requirement.

Regards,

Rasly.K

Anonymous
Not applicable
Author

Hi Rasly sorry for the delay.

Unfortunately i cannot open the file as i am in Personnal Edition.

Many thanks though. My knowledge in Input sum has increased since then

Thanks