Tickets count app

P_S — Mon, 08 Jul 2019 05:02:29 GMT

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.

Re: Tickets count app

Lisa_P — Mon, 08 Jul 2019 05:35:20 GMT

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)

topic Tickets count app in App Development

Tickets count app

Re: Tickets count app