topic Re: Current week in QlikView

Current week

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to display the dimension as current week like below

My date field is Tran_Date

Day1

Day2

Day3

Day4

Day5

Day6 this is current week except sunday

how can I write the calculation condition?

Re: Current week

prat1507 — Fri, 01 Jun 2018 14:23:56 GMT

Can you plz elaborate a bit.

Regards
Pratyush

Re: Current week

soniasweety — Fri, 01 Jun 2018 14:26:13 GMT

I want to show the bar chart for current weekdays excluding sunday with the attached format

so how to achieve this?

dim= Tran_Date

measure= count(id)

Re: Current week

prat1507 — Fri, 01 Jun 2018 14:40:27 GMT

You can exclude the dimension using this

=if(date(DateField,'WWWW')<>'Sunday',

pick(match(date(DateField,'WWWW'),'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'),

'Day1','Day2','Day3','Day4','Day5','Day6')

Regards

Pratyush

Re: Current week

soniasweety — Fri, 01 Jun 2018 15:10:24 GMT

Hi ,

thanks for reply. but I need to show current week only

now your expression is showing to over all I think?

or else can I restrict current week in measure? then how can I ?

count(Id)

Re: Current week

soniasweety — Fri, 01 Jun 2018 16:32:47 GMT

Hi sunny

any idea

Sunny Talwar

Re: Current week

shiveshsingh — Fri, 01 Jun 2018 17:58:34 GMT

You can use the max week values in your expression..can you try this?

count({<Week = {"$(=Max(Week))"}>}ID)

Re: Current week

MarcoWedel — Fri, 01 Jun 2018 22:05:19 GMT

Is there any particular reason for not continuing this question in your thread Display name ?

Re: Current week

soniasweety — Sat, 02 Jun 2018 04:38:58 GMT

‌if I use this I vill get including Sunday also?

i Want to exclude Sunday in this

Re: Current week

soniasweety — Sat, 02 Jun 2018 04:39:28 GMT

yyes that was different and now logic got changed by cliebt‌

Re: Current week

Anil_Babu_Samineni — Sat, 02 Jun 2018 04:57:23 GMT

Not sure sure your request - But, You can think something like below

WeekDay(DateField) as WeekDay,

Week(DateField) as Week

And measure

Count({<WeekDay -= {'Sun'}, Week = {$(=Max(Week))}>} ID)

Re: Current week

soniasweety — Sat, 02 Jun 2018 05:53:53 GMT

Hi Anil Samineni

requirement is

I need to show the chart weekdays count(id) with dimension values like day1 to day6

Re: Current week

Anil_Babu_Samineni — Sat, 02 Jun 2018 05:55:41 GMT

Can you provide data set to test?

Re: Current week

soniasweety — Sat, 02 Jun 2018 06:00:58 GMT

my data look like below

Tran_Date	ID
1/6/2018	1
2/6/2018	2
3/6/2018	3
4/6/2018	4
5/6/2018	5
6/6/2018	6
7/6/2018	7
8/6/2018	8
9/6/2018	9
10/6/2018	10
11/6/2018	11

Re: Current week

Anil_Babu_Samineni — Sat, 02 Jun 2018 06:08:48 GMT

This is not you are looking or am i missing something?

Re: Current week

soniasweety — Sat, 02 Jun 2018 06:17:45 GMT

can you attach the app ?

Re: Current week

Anil_Babu_Samineni — Sat, 02 Jun 2018 07:22:36 GMT

Not sure what App you are expecting? That is straight forward, Anyway PFA

Re: Current week

soniasweety — Sat, 02 Jun 2018 07:50:49 GMT

but this is not am expecting

the result should be like

input:

LOAD *,WeekDay(Tran_Date) as WeekDay Inline [

Tran_Date, ID

4/6/2018, 4 ----

4/6/2018, 10 ----- here 4th jun 2018 Monday in chart Day1 -count 2 result like that all [excluding sunday]

5/6/2018, 5

5/6/2018, 12

6/6/2018, 6

7/6/2018, 7

8/6/2018, 8

8/6/2018, 16

];

output:

bar chart:

dim: values

Day1 Means Mon till Day6 means sat

Day1 Day2 Day3 Day4 Day5 Day6 each day count has to show on bar.

Re: Current week

Anil_Babu_Samineni — Sat, 02 Jun 2018 08:03:30 GMT

Not clear Can you share real data and expected output to test? That will en count you.

Re: Current week

soniasweety — Sat, 02 Jun 2018 08:58:55 GMT

in attached sample expected output drawn.

input value I don't have dayname column I want to create it from tran_date field