topic Re: dispaly quarter value - without using data model in QlikView

dispaly quarter value - without using data model

settu_periasamy — Mon, 09 Sep 2013 06:30:58 GMT

Team,

I have the data with date values. I need to create the list box to display the Quarter values (Q1, Q2, Q3 and Q4) without modifying the data model(Actually, I don't have the access for data model. ).

Is it possible to do that?

Regards,

Sethu

Re: dispaly quarter value - without using data model

er_mohit — Mon, 09 Sep 2013 06:36:36 GMT

its better to create in script side if don't then use list box-->properties-->general--> fields drop down it go to expression side

write this

'Q' & Ceil(Month(TempDate)/3) if you want to start quarter first to jan

if you need to start quarter from apirl then try this expression

'Q'&If(Month(QuarterStart(TempDate,4))='1' ,4,Div(Month(QuarterStart(TempDate,4)),3))

here TempDate is my date field replce with your own

hope it helps

Re: dispaly quarter value - without using data model

narender123 — Mon, 09 Sep 2013 07:15:30 GMT

Hi,

For linking between your Quarter and data ,you need to add quarter in script.

eg:

calender:

Load * inline

[

Month,Quarter

jan,Q1

feb,Q1

mar,Q1

apr,Q2

may,Q2

...........

.........

dce,Q4

];

join this Month with your fact table Month.

if you have monthno in fact table then you could write 1,2,3,4..12 in themonth column in replacement of jan,feb..dec and join with monthno of fact table.

Thanks

Narender

Re: dispaly quarter value - without using data model

settu_periasamy — Mon, 09 Sep 2013 07:19:11 GMT

Hi Mohit,

Thank you.

It was helpful. it will display the quarter values based on the selection. I need the Quarter valued based on all records.

Thanks in Advance.

Re: dispaly quarter value - without using data model

settu_periasamy — Mon, 09 Sep 2013 07:21:16 GMT

Hi Narendar,

I need to display the quarter values, without editing the script. (Expression would be fine)

Re: Re: dispaly quarter value - without using data model

narender123 — Mon, 09 Sep 2013 07:33:25 GMT

Hi Settu,

Please see the attch file.

I have taken the month field data from xl file to show the demo.But in your data model there should be month field ,so you dont need to create xl file in your QVW. Just take the month field data that is already in your qvw file.

Thanks.

Re: dispaly quarter value - without using data model

er_mohit — Mon, 09 Sep 2013 07:33:37 GMT

that's why i told you first its better to do it in script side

it doesn't effect on your data model where is your date present there you add this farmula because on expression side it only based on that records rather on other

hope it helps you

Re: dispaly quarter value - without using data model

settu_periasamy — Mon, 09 Sep 2013 07:49:38 GMT

Hi Narendar,

Already i have the date and Month field in my qvw file. Just i need to display the all Quarter values without modifying the script.

I tried the Mohit Answer. (Q' & Ceil(Month(TempDate)/3)) - This display the quarter values based on the selection. But I need to display the all quarter values.

can you help me on this?

Re: dispaly quarter value - without using data model

settu_periasamy — Mon, 09 Sep 2013 07:58:04 GMT

Understood Mohit. The probelm is, i don't have the access to modify the script.

Re: Re: dispaly quarter value - without using data model

narender123 — Mon, 09 Sep 2013 08:02:04 GMT

Sorry Settu, bymistake i didnt show the qvw in last reply.Now i have attached it.please see it.

Thanks.

Narender