There is a function in Excel called the GCD( ) function. (Global Common Denominator). Do we have anything similar to that available in Qlik Sense? (it is used for calculating ratio too)
Check this link
Re: How to calculate the GCD(Greatest Common divisor)
That article recommend a macro function for GCD, unfortunately I don't think I have macros in Qlik Sense. Can someone confirm whether or not we can create macros / functions in Qlik Sense please?
here is the answer?
Will the Macros Works In QlikSense?
may be helpful for you?
Retrieving data ...