I want to show the field directly from database in qlikview

[udaya_kumar]

Hi,

i have field by name CurrentMonth, in that the values look like 'Factor 0.0', 'Factor 0.2'.

something like this, but i want to show this values directly in Qlikview.

how can i use the fieldname CurrentMonth to show these values in Front End Qlikview?

Can anyone help me?

[CELAMBARASAN]

Hi,

     Are you looking for list box or something else?

Celambarasan

[udaya_kumar]

Hi,

i want to show this field in the straight table.

am using straight table to show this field as an expression

[deepakk]

hi ,

try using the only function

Only(FieldName).

If you can attach some sample file then it would be more clear.

Deepak

[udaya_kumar]

RuleID	TimeFrame_From	TimeFrame_To	CurrentMonth
1	02/02/12	02/03/12	Factor: 0.0
2	some date	some date	Factor: 0.2
3	some date	some date	Factor: 0.3

I have data like this in database,

in Qlikview, in the straight table,

i need to show the CurrentMonth value ' Factor 0.0' something like this in the straight table.

but the condition am using is

=IF(MonthName(AddMonths(Today(),-1))=TimeFrame_From, CurrentMonth))

i have used expression like this, but its not working.

i need to show that currentMonth value in the straight table by matching the TimeFrame Date with the Current date like March 2012.then it should show the March data for CurrentMonth as Factor 0.0.

so how to show this in qlikview?

can anyone help me please?

[CELAMBARASAN]

Hi,

     Try with this expression.

     =IF(TimeFrame_From>=MonthStart(Today(),-1) And TimeFrame_From<=MonthEnd(Today(),-1), CurrentMonth)

Celambarasan

[udaya_kumar]

Hi,

I tried but its not showing any value,

its showing just - in the place of the cell in the straight table

[udaya_kumar]

Hi,

If am matching that TimeFrame_From in the expression with the current system date, then how i can display the value of CurrentMonth in the expression?

like for Volume, we show like Sum(Volume) as an expression.

but this is a direct field in the database, but i want to show this field directly in qlikview.

how can i show that value?

if i use expression like if(some condition, CurrentMonth)

this expressoin is not working, its not giving any value in the cell in the straight table.

how can i show these values?

please help me, am stuck in this.

[CELAMBARASAN]

Hi,

     It may be a time stamp problem

     Try with this using num

     =IF(Num(TimeFrame_From)>=Num(MonthStart(Today(),-1)) And Num(TimeFrame_From)<=Num(MonthEnd(Today(),-1)), CurrentMonth)

Celambarasan

[udaya_kumar]

Thanks for reply celambarasan,

but i still not getting any values in the table.

its showing just '-' in that place.

dont know what is the problem.

we need to check the TimeFrameDate then according to that, we have to show the CurrentMonth value.

but the expression which you have given is not working