topic Re: Help me to generate report in QlikView

Help me to generate report

Re: Help me to generate report

Re: Help me to generate report

Re: Help me to generate report

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I want to generate the following report

Note : 1. All the above fields are coming from same table.
2. For field First date and Last date there are some calculations.

First date - Display Bid value Day before Yesterday
Last date - Display Bid value Yesterday.

3. Except the above two fields all other fields are direct fetch.

Kindly please help me how to generate this report.

There are certain queries:
1. Should i use pivot table or straight table and why ?
2. If i write a load query can i write where clause or filter column wise logic
eg: Load
ISIN,
Quote Name,
Bid as First date where Date = Today()-2 ,
Bid as Last date where Date = Today()-1
From ABC table.
Can i have such kind of queries ?
If not, how can i achieve the same ?

Thanks

jonas_rezende — Mon, 25 Jul 2016 15:27:44 GMT

Hi, Girish Inani.

What you have in script?

If possible, share your qvw.

Regards,

Jonas Melo.

vishsaggi — Mon, 25 Jul 2016 15:43:26 GMT

2. For field First date and Last date there are some calculations.

First date - Display Bid value Day before Yesterday
Last date - Display Bid value Yesterday.

--- Can we know what kind of expression is used in calculating BidValue? Where is this BidValue coming from?

2. If i write a load query can i write where clause or filter column wise logic
eg: Load
ISIN,
Quote Name,
Bid as First date where Date = Today()-2 ,
Bid as Last date where Date = Today()-1
From ABC table.

--- You cannot have Where statement inside LOAD so you can use an IF statement if you want. Like

LOAD ISIN, QuoteName,

IF([First date] = Today()-2, [First date]) AS BidFirstDate,

IF([Last date] = Today()-1, [Last date]) AS BidLastDate

FROM ABC;

Please share your sample data or qvw file to get more help.

Thanks,
V.

Quote Name

First Date

Price movement

Position analysis

jonas_rezende — Tue, 26 Jul 2016 14:03:39 GMT

Hi, vishaggi.

Could you describe an example in a spreadsheet to understand that you want to achieve?

Regards,

Jonas Melo.