
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How load only a particular day of week
Dear all,
I have a question:
1. I have a table that contains my daily balances. I need to create a chart giving the balance for each friday of week.
My idea is to load from database only those records where the date is a friday.
Is there any way to do this chart without to have a different select and have in the same app the possibility to view the balance and a chart that shows only the records where the date is a friday?
Thank you
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Massimo,
Do you have Weekday in your Calendar?
create weekday by adding it in your script
WeekDay([DATE_REF]) AS Weekday
And then use the Expression
SUM({<Weekday ={'Fri'}>}BALANCE_CVT2).


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes if you have Date as your dimension you could say for your expression
SUM({<Weekday ={'Fri'}>}Amount)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update: Misread the question. I think you would be able to use the above expression to do the job for you. Just have a column name Weekday in your script (most likely within your Master Calendar (WeekDay(Date) as Weekday)
TempTable:
LOAD Date,
yourOtherColumns
FROM xyz.xlsx;
Table:
NoConcatenate
LOAD *
Resident TempTable
Where WeekDay(Date) = 'Fri';
DROP Table TempTable;
Hope this helps.
Best,
S

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure what you exactly want to show in the chart
I would define a dimension with weekend(date, 0, -2) which gives you friday as date
then your expression should only sum for the fridays

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Alan,
many thanks for your reply.
I have used the date into the dimension als as follow =(weekend([DATE_REF], 0, -2) ) and see the chart with only the fridays.
But using your suggestion to calculate the sum of only records having the sum only of friday records it doesn't work.
The expression is: SUM({<Weekday ={'Fri'}>}BALANCE_CVT2).
Any suggestion?
Thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Sunidia,
i would like to have just one app that could give usrs way to determine the balance to a certain date and at same time to see the chart by all fridays of week. May I add to the same load of all records an additional load as for your example and use two different load in the same app?
Thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Rudolf,
yes it works for the dimension but the SUM is forr all records of the week. Any ideas on how to say to sumn only those records where the date is a friday?
thank you


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Massimo,
Do you have Weekday in your Calendar?
create weekday by adding it in your script
WeekDay([DATE_REF]) AS Weekday
And then use the Expression
SUM({<Weekday ={'Fri'}>}BALANCE_CVT2).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Massimo,
could you please attach a file?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Alan it works perfectly! Thank you

- « Previous Replies
-
- 1
- 2
- Next Replies »