Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help me to generate report

Hi guys,

I want to generate the following report

   

ISINQuote NameFirst DateLast DatePrice movementPosition analysisSource

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

3 Replies
jonas_rezende
Specialist
Specialist

Hi, Girish Inani.

What you have in script?

If possible, share your qvw.

Regards,

Jonas Melo.

vishsaggi
Champion III
Champion III

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
Specialist
Specialist

Hi, vishaggi.

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

Regards,

Jonas Melo.