topic Re: Date in QlikView

Date

Tue, 15 Sep 2015 06:38:55 GMT

Hi can some one explain what does this expression do ? this is in the expression Label

IF(GetCurrentField(CG_Period)<> 'CDate',1,0) and there is red mark on CG_Period which is a cyclic group name , Can some one please correct it ?

Re: Date

sunny_talwar — Tue, 15 Sep 2015 06:41:05 GMT

This expression is currently assigning 1 to the expression label when you are on CDate in your cycle group. Otherwise it assigns 0. What are you trying to do? Unless you tell us your expectation, we won't be able to help you much, because syntax wise there is nothing wrong about the expression.

Re: Date

qlikmsg4u — Tue, 15 Sep 2015 06:42:24 GMT

If we use Cyclic group in expression it will show red mark although it the expression is correct

Re: Date

engishfaque — Tue, 15 Sep 2015 06:42:46 GMT

Dear Wrestler,

Here it's,

if GetCurrentField(CG_Period) not equal to CDate, then return 1, else return 0

Kind regards,

Ishfaque Ahmed

Re: Date

PradeepReddy — Tue, 15 Sep 2015 06:49:48 GMT

there is no error in the expression..

whenever we use the Cyclic/Drilled down group name in the GetCurrentField(), it shows the error mark...

Re: Date

Tue, 15 Sep 2015 06:53:16 GMT

Hi Pradeep,

Check if that cyclic group or fields are available. If it is not available then it shows Red cross mark.