Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have a table as shown below
Id | Orderdate | Suppdate | Deliverdate | ||
1 | 5-Apr | 5-Jan | 4-Feb | ||
2 | 1-Feb | 3-Jan | 4-May | ||
3 | 5-Mar | 5-Jan | 4-Feb | ||
4 | 4-Jan | 12-Feb | 12-Mar | ||
5 | 3-Apr | 3-Jan | 4-May | ||
6 | 3-May | 5-Jan | 4-Feb | ||
7 | 8-May | 12-Feb | 12-Mar |
my requirement is , if i select any month /date , i need to get the total id based on the orderdate and deliverdate excluding suppdate . But however, all the dates are linked to master calender.
for example:
if i select apr or feb the first id should appear but if i select jan the first id should not appear.
can anyone help me with syntax
Thanks in advance
I think you need to implement a Canonical Date.
- Marcus
Thanks for reply ..
we tried but could not exclude the supp dates from the month/date we select .
If you used a single-master-calendar you will be by a selection always exclude all other values. Now you could overwrite these selection/excluding with set analysis within the expressions - but it could be quite complicated to cover with them a wide range of queries. I assume you won't have these single case - there will be probably many more query-combinations in this direction and also reverse.
Therefore I suggest to get as nearly as possible within the script and if the canonical dates couldn't completely cover your needs you migt to combine these approach with Why You sometimes should Load a Master Table several times.
- Marcus
May be if you can share a sample we might be able to play around with it to get a solution. Difficult to process it in the mind without trying it out
sir, consider the above data as sample data .
I was hoping for a more qvw sample
Preparing examples for Upload - Reduction and Data Scrambling