Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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