topic Re: excluding date in QlikView

excluding date

Anonymous — Fri, 27 May 2016 06:33:47 GMT

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

Re: excluding date

marcus_sommer — Fri, 27 May 2016 07:03:01 GMT

I think you need to implement a Canonical Date.

- Marcus

Re: excluding date

Anonymous — Fri, 27 May 2016 07:31:01 GMT

Thanks for reply ..

we tried but could not exclude the supp dates from the month/date we select .

Re: excluding date

marcus_sommer — Fri, 27 May 2016 07:45:34 GMT

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

Re: excluding date

sunny_talwar — Fri, 27 May 2016 09:17:55 GMT

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

Re: excluding date

Anonymous — Fri, 27 May 2016 09:27:30 GMT

sir, consider the above data as sample data .

Re: excluding date

sunny_talwar — Fri, 27 May 2016 09:35:12 GMT

I was hoping for a more qvw sample

Preparing examples for Upload - Reduction and Data Scrambling