Discussion board where members can get started with QlikView.
I have several columns of data in Excel I am pulling into Qlik.
One for "current monthly" that uses a formula, which is last months data when the report is being done
One that names the category
One that names the type
One that names the issue
I want to make a simple table to display: Issue (if "current monthly", if"category", if "type") and the Def% will come later
ISSUE QTY LAST MONTH TOTAL QTY DEF%
Go to Solution.
I got it figured out.
View solution in original post
please provide a smaple data file and expected output file so that you will get a reply ASAP from our Qlik folks