topic Re: Inputsum with Set Modifier in QlikView

Inputsum with Set Modifier

Anonymous — Wed, 30 Aug 2017 05:52:48 GMT

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

Re: Inputsum with Set Modifier

kusumanchir — Wed, 30 Aug 2017 07:21:09 GMT

Hi Byran,

Please try this,

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

Regards,

Rasly.K

Re: Inputsum with Set Modifier

kusumanchir — Wed, 30 Aug 2017 07:37:46 GMT

Hi Byran,

Please find the sample attached with set analysis expression.

-Rasly.K

Re: Inputsum with Set Modifier

Anonymous — Wed, 30 Aug 2017 10:58:28 GMT

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

Re: Inputsum with Set Modifier

kusumanchir — Wed, 30 Aug 2017 12:41:18 GMT

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

Re: Inputsum with Set Modifier

kusumanchir — Wed, 30 Aug 2017 12:51:46 GMT

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

Re: Inputsum with Set Modifier

Anonymous — Mon, 18 Sep 2017 11:52:12 GMT

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