Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need help with application development. I am trying to create tickets count application in Qlik Sense. The condition is "Cust Name" sales start from April 2019 until December 2019 and every 2100 sales they will get one ticket. The product must be only any Qlik and X product. The application should sum all sales from each customer from Qlik and X product and give the number of tickets. So I use
If(Match([Fiscal Month], 'Apr-19', 'May-19', 'Jun-19', 'July-19', 'Aug-19', 'Sep-19', 'Oct-19', 'Nov-19', 'Dec-19'),
If(Wildmatch(VDR1, 'QLIK*', 'X'),
If(Sum(Sales) < 0, 0, Floor((Sum(Sales))/21000)
),0
)
)
But the result show as
The result missing many values. Cloud you give any advice? I also attach the table sample with this post. Thank you in advance.
Try this:
Floor(Sum({$<[Fiscal Month]={'Apr-19', 'May-19', 'Jun-19', 'July-19', 'Aug-19', 'Sep-19', 'Oct-19', 'Nov-19', 'Dec-19'}, VDR1={"QLIK*"}+{X}>}Sales)/2100)
Try this:
Floor(Sum({$<[Fiscal Month]={'Apr-19', 'May-19', 'Jun-19', 'July-19', 'Aug-19', 'Sep-19', 'Oct-19', 'Nov-19', 'Dec-19'}, VDR1={"QLIK*"}+{X}>}Sales)/2100)