QlikView App Dev

[#1]

Hi guys,

I want to generate the following report

ISIN	Quote Name	First Date	Last Date	Price movement	Position analysis	Source

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]

Hi, Girish Inani.

What you have in script?

If possible, share your qvw.

Regards,

Jonas Melo.

[vishsaggi]

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.

[jonas_rezende]

Hi, vishaggi.

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

Regards,

Jonas Melo.