topic Re: Filter Q from Quarter Field in QlikView

Filter Q from Quarter Field

akpofureenughwu — Tue, 08 Nov 2016 07:15:52 GMT

Good day everyone,

I have a design in my day field, I get day 1, day 2 ............. and day as well as Quarter. Q1,Q2.... and Q

I don't want day and Q in the respectively fields

How do I filter it.

Below is the script I used

LOAD *,

Month(Date) as Month,

WeekDay(Date) as WeekDay,

'Week ' & Week(Date) as Week,

Year(Date) as Year,

'Q'& Ceil(Month(Date)/3) as Quarter,

'Day '& Day(Date) as Day,

Day(Date) as nDay;

Thanks

Re: Filter Q from Quarter Field

jonathandienst — Tue, 08 Nov 2016 07:18:22 GMT

>>I don't want day and Q in the respectively fields

Then don't add them in your script...

'Q'& Ceil(Month(Date)/3) as Quarter,

'Day '& Day(Date) as Day,

Re: Filter Q from Quarter Field

tresB — Tue, 08 Nov 2016 07:19:13 GMT

Just omit the textual part like:

LOAD *,

Month(Date) as Month,

WeekDay(Date) as WeekDay,

'Week ' & Week(Date) as Week,

Year(Date) as Year,

'Q'& Ceil(Month(Date)/3) as Quarter,

'Day '& Day(Date) as Day,

Day(Date) as nDay;

Re: Filter Q from Quarter Field

akpofureenughwu — Tue, 08 Nov 2016 07:31:56 GMT

I have removed that line of script... 'Q' and 'Day'...

But the Q is now expressed in number ie 1,2,3 and 4 not Q1,Q2,Q3 and Q4

Same can be said of day..

Can I have the quarter expressed as Q1,Q2,Q3 and Q4..

Thank you for your response

Re: Filter Q from Quarter Field

tresB — Tue, 08 Nov 2016 07:38:52 GMT

I am not sure if I understood you right. And I hope that you have understood what and how it happens when you remove/add 'Q' from/to the expression. If you want the 'Q' to be there for quarter, just leave the 'Q' there like:

'Q'& Ceil(Month(Date)/3) as Quarter,

Re: Filter Q from Quarter Field

akpofureenughwu — Tue, 08 Nov 2016 08:01:21 GMT

If I use this line of command: 'Q'& Ceil(Month(Date)/3) as Quarter, I will get the Q,Q1,Q2,Q3 & Q4 include the field

IF I use this line of command: Ceil(Month(Date)/3) as Quarter, I will get 1,2,3 & 4 in the quarter field

Is it not possible for me to get this Q1,Q2,Q3 and Q4 only?

Thanks for your response

Re: Filter Q from Quarter Field

tresB — Tue, 08 Nov 2016 08:24:16 GMT

If you are getting a 'Q' without any number following that probably means some of your dates are not present or proper date. I would look into that issue first. However, to solve it in expression you could try like:

if( Isnum(Date), 'Q')& Ceil(Month(Date)/3) as Quarter,

Re: Filter Q from Quarter Field

akpofureenughwu — Tue, 08 Nov 2016 08:43:22 GMT

Thank you Tresesco