Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

Modulo function

Hi,

Please can you help me I can not identify the error

=mod(sum([Nombre de voix exprimés]), $(vQuotient_Electoral))

vQuotient_Electoral = num($(vNombre_Bulletins_Valide_Exprimés)/24,'00')

vNombre_Bulletins_Valide_Exprimés= $(vNombre_bulletins_exprimes) - ($(vBulletins_blancs)+$(vBulletins_nuls)+ $(vNombre_voix_3))

vBulletins_blancs=sum( {<[circonscription électorale] ={'Ville'}>} [Bulletins blancs])


Best regards

Maurice

3 Replies
Anil_Babu_Samineni

Can you try this in Text box and show the value what you getting? More help https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/GeneralNu...

=$(vQuotient_Electoral)

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)
MauriceLudo
Creator II
Creator II
Author

= $(vQuotient_Electoral) = 751

marcus_sommer
MVP & Luminary
MVP & Luminary

Both parameter of the mod-function must be an integer whereby a formatting with num won't be sufficient else you will need a round-function like round/ceil/floor to ensure that they are really an integer.

- Marcus