Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

Brach Level Trading Days

Hello Experts...

Need your help!

We have list of Branches with their Opening/Start Date.

Also, have prepared a table showing Trading Day... i.e. 1 for Full Day, 0.5 for Saturday and 0 for Holiday

I have created two variables

vFromDate and vToDate

Now Question is :

Need a Final Straight or Pivot Table showing Total Trading Days based on Branch Level.

If vFromDate > BranchStartDate,

SUM of Trading Day between vFromDate to vToDate

else

SUM of Trading Day between BranchStartDate to vToDate

Application enclosed for your reference.

3 Replies
datanibbler
Champion
Champion

Hi Manish,

I had a similar issue at a time.

- You have to generate a StartDate (either branchstartdate or vFrom, whichever is later) in the script.

- In a calendar, you can generate a field that will be 1 for Mo-Fri, 0.5 for Sat, 0 for Sunday
  => You can use a mapping_table to also get the holidays and assign a 0 value to them like you do for Sundays. (still on scripting level)

- Then you can quite easily sum up the Trading_day values you have between your [generated StartDate] and your vTo

HTH

Best regards,

DataNibbler

Nicole-Smith

How do you know what Trading Days are related to which Branches?  Your two tables are not linked in the .qvw file.

vidyut
Partner
Partner

Try this Expression:

Sum(If(BranchStartDate>=vFromDate,

  If( [Trading Date]>=BranchStartDate and [Trading Date]<=vToDate,TradingDay),

  If( [Trading Date]>=vFromDate and [Trading Date]<=vToDate,TradingDay)))

This works in your application.

Cheers,

Vidyut