topic Re: Passing value from different table to For loop in QlikView

Passing value from different table to For loop

jsk_sathis — Thu, 24 Jan 2019 06:19:47 GMT

Hi ,

I need to pass a set of values from a Column say "Reporting date." , which has only the month end dates in it.

Now , I have to filter certain records based on each reporting date and store it as a Qvd .

Use case 1:

Data:

Document No	Value	Posting Date
1	727	01.01.2017
2	563	05.01.2017
3	112	15.02.2017
4	816	29.03.2017
5	663	04.04.2017
6	868	09.05.2017
7	491	19.05.2017
8	985	20.06.2017
9	499	11.09.2017
10	968	12.10.2017
11	779	17.11.2017
12	599	21.12.2017
13	195	22.12.2017
14	490	25.12.2017

Reporting Date Table

Reporting Date
31.01.2017
28.02.2017
31.03.2017
30.04.2017
31.05.2017
30.06.2017
31.07.2017
31.08.2017
30.09.2017
31.10.2017
30.11.2017
31.12.2017

I need to pass the values of Reporting Date and fetch the respective Documents No and store it in individual Qvds with respect to each value in Reporting Date.

Kindly suggest your comments .

Thanks,

Re: Passing value from different table to For loop

HirisH_V7 — Thu, 24 Jan 2019 06:31:00 GMT

I didn't able get your requirement. But i can suggest to use ,

Monthend(Posting Date) as ReportingDate

Beside bringing it from another table. Also pl let me know if i am missing anything here.

Re: Passing value from different table to For loop

jsk_sathis — Thu, 24 Jan 2019 07:56:38 GMT

Hi ,

The Data is like this , Reporting date is the only column in a table, based on this date I need to fetch the Document Nos for which its respective Posting date is before the Reporting date.

Say for example

Reporting date is 31.01.2017 ( Ref to the table provided)

The result should be like

Document No	Value	Posting Date	Reporting date
1	799	01.01.2017	31.01.2017
2	659	05.01.2017	31.01.2017

Based this data I will have create a trend for Document No for a period.

As I don't have any link between Date & Fact Table , I unable to reach the requirement.

Re: Passing value from different table to For loop

HirisH_V7 — Thu, 24 Jan 2019 08:43:09 GMT

Then you can create a new field in your table like this,

Monthend(Posting Date) as ReportingDate