

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mathematical question
How can i put this formule in Qlik Sense?
dX = (X - 155000) * 10 ^ -5
dY = (Y - 463000) * 10 ^ -5
I tried:
(X - 155000) * 10 ^ -5 As dX,
(Y - 463000) * 10 ^ -5 as dY
But Qlik Sense doesn't recognize the " ^ " symbol.
Thank you in advance,
Kind Regards,
Isabelle
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
Pow((X - 155000) * 10, -5) as dX,
Pow((Y - 463000) * 10, -5) as dY
UPDATE: Just realized from Gysbert's post that the whole thing is not raise to -5. May be this:
(X - 155000) * (Pow(10, -5)) as dX,
(Y - 463000) * (Pow(10, -5)) as dY

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
Pow((X - 155000) * 10, -5) as dX,
Pow((Y - 463000) * 10, -5) as dY
UPDATE: Just realized from Gysbert's post that the whole thing is not raise to -5. May be this:
(X - 155000) * (Pow(10, -5)) as dX,
(Y - 463000) * (Pow(10, -5)) as dY

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
(X - 155000) /100000
talk is cheap, supply exceeds demand
