Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
P_S
Partner - Contributor III
Partner - Contributor III

Tickets count app

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

Qlik Result.png

The result missing many values. Cloud you give any advice? I also attach the table sample with this post. Thank you in advance.

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

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)

 

View solution in original post

1 Reply
Lisa_P
Employee
Employee

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)