Discussion Board for collaboration on QlikView Scripting.
Hi All,I need to bounce this off a fresh set of eyes!
1) First issue is the EndDate keeps reverting to a Num Date why?
2) I have a Script which is using Interval Match with Extended Syntax and mapping
CostTable with Start, End Dates and NewCosts and a Salestable with a InvDate.
I had to use Previous and order by to clean up the EndDate but you will see in example.
When I trying to Map the NewCost price field it seems I can only get the Lowest or Highest dates to Map.
I have attached an Example Qvd File the Orange Colored table has a SalesCost field at end of table also I have created a Straight table 'Green' with a expression to calc NewCost*Qty field which works?
I have missed something in my script?
any help appreciated regards Peter
Go to Solution.
I have updated the script. Please reload and see the result
I am unable to open your file. Can you please attach the script in notepad.
I have upload Script thanks Vijay
You are a Champion!
After a bit of testing and looking at your script all looks good, I have learnt a few things
Thankyou very much!
best regards Peter
I've a table with Project Nos., StartdateProject,EnddateProject & Revenue
I need to a create a Calender so that on selecting a particular Year , all the projects starting or ending in this Year are displayed.
Moreover, on selecting the Quarters (Q1 or Q2 or Q3 or Q4) the Revenue should be shown only for that Quarter.
For eg. if a project has Yearly Revenue of 1000 & the project runs from 1 Jan, 2015 to 31 Dec, 2015
then on Selecting Q1, Revenue displayed should be 1000/4(=250).