Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an Excel file that I need to load into Qlikview where I need to take the original table and create a new table while also retaining the original table by doing the following and load both into the dashboard:
I've attached a spreadsheet with three tabs. The first tab is the Original Data. The second is the new table I need and the third tab is a sample pivot table I need to build in Qlikview.
I was able to solve the problem with set analysis without having to merge any rows.
1.) Sum({<estimate_id = {"*"}, estimate_item_id = {"*"}>} Budget_Cost) //Labeled expression Budget Cost
2.) Sum({<estimate_id = {"*"}, estimate_item_id = {"*"}>} Current_Cost) //Labeled expression Current Cost
And then
3.) ([Budget Cost] - [Current Cost])
This might be up your alley with your experience and knowledge.
I was able to solve the problem with set analysis without having to merge any rows.
1.) Sum({<estimate_id = {"*"}, estimate_item_id = {"*"}>} Budget_Cost) //Labeled expression Budget Cost
2.) Sum({<estimate_id = {"*"}, estimate_item_id = {"*"}>} Current_Cost) //Labeled expression Current Cost
And then
3.) ([Budget Cost] - [Current Cost])