Help with formulae

[#1]

Hi,

I have some SQL I used before with SSRS and I want to replicate the logic in Qlik and am stuck at this point:

(NumberOfTickets/Hours worked(for all months in the year to date)/Number of months in the year)*1,000,000

I would also like the 1,000,000 to be interchangeable from 1 to 2 million.

Help with best way to do this would be greatly appreciated.

[Ricardo_Gerhard]

Dear GR,

   Did you try the funcion Round?

   Follow the link with explanation: https://help.qlik.com/pt-BR/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFun...

Regards

Ricardo Gerhard

[brunobertels]

Hi

may be somethink like this

where Date : is your data base date field

count(NumberOfTickets)

/

Sum({<Year,Quarter,Month,Week, Date= {"$(='>=' & Date(YearStart(Max(Date)), 'YourDateFieldFormatHere') & '<=' & Date(Max(Date), 'YourDateFieldFormatHere'))"}>} "Hours worked"),

/

num(month(max(Date)))

*

1000000

to change 1 million to 2 million : make two mesures or use variable button to select 1 million or 2 : use qsvariable extension available in qlik branch site

hope it helps

Bruno