topic Re: Variables in QlikView

Variables

Wed, 27 Nov 2013 10:25:01 GMT

Guys, I am very new to Qlikview and need to get a good understanding on how to create and use variables in my application.

I am analysing our Debtors Book and we are trying to understand when the book had grown before certain migration phases or after.

So I need to create 4 phase variables that has the following expression and then I need to plot on a graph.

if(Posting Period >='2005-01-01' and Posting Period <='2013-03-24','Phase_1',
if(Posting Period >='2013-03-25' and Posting Period <='2013-06-23',' Phase _2',
if (Posting Period >='2013-06-24' and Posting Period <='2013-08-25',' Phase _3',
if(Posting Period >'2013-08-26',' Phase _4'

Posting Period is a field that I bring in from my QVD. Phase is a field I will need to be a dimension…

Re: Variables

salto — Wed, 27 Nov 2013 10:29:35 GMT

Hello,

Your expression, in the QV script, should look like this (more or less):

if("Posting Period" >='2005-01-01' and "Posting Period" <='2013-03-24','Phase_1',

...

if("Posting Period" >'2013-08-26','Phase _4')) AS FieldName

FieldName will contain the Phase (1, 2 3 or 4). It is a field that you will be able to use as a dimension in your QV document, without changes.

Hope this helps.

Re: Variables

Wed, 27 Nov 2013 10:38:43 GMT

Thank you Salto...I was on the right track and you helped confirm my logic:) Much appreciated

Re: Variables

udit_kumar_sana — Wed, 27 Nov 2013 10:38:52 GMT

hi,

You can write the same expression at script level forming the field phase.

if(Posting Period >='2005-01-01' and Posting Period <='2013-03-24','Phase_1',

if(Posting Period >='2013-03-25' and Posting Period <='2013-06-23',' Phase _2',

if (Posting Period >='2013-06-24' and Posting Period <='2013-08-25',' Phase _3',

if(Posting Period >'2013-08-26',' Phase _4' )))) as Phase

Thanks & Regards,

Udit