topic Re: Expression in QlikView

Expression

Tue, 15 Oct 2013 09:41:30 GMT

hi,

I am using pivot table. in image column if count of green arrow is greater than 2 is shoul show green in status and if count of red is greater than 2 it should show red. how to apply expression in status column.

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 09:44:37 GMT

What expression your using to show the arrows? because it depends on that. We can control it using expression again it depends.

Re: Expression

Tue, 15 Oct 2013 09:48:53 GMT

Hi Celambarasan,

I am using image from expression window for green arrow but we can use green from trend column also.

Regards,

Piyush

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 10:00:07 GMT

I meant is there any logic is there to apply green or red or yellow.

Have you applied logic something like If(Value>50, Green, if(Value > 25, Yellow, Red ))?

Re: Expression

Tue, 15 Oct 2013 10:05:10 GMT

Hi,

I am using set analysis for that like =if(count({<Trend='Green>}Dt)>=2,'Green') but it is not working.

Re: Expression

saumyashah90 — Tue, 15 Oct 2013 10:10:21 GMT

Hi Piyush,

What you can do is. Count of image
i.e after you are done with images take an another expression counting that image and show RAG based on it

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 10:15:40 GMT

Try this.

If(Count(Total<Week123> {<Trend='Green>} Dt) >=2, 'Green')

Re: Expression

Tue, 15 Oct 2013 10:34:57 GMT

Hi Celam,

It is showing error at the second brases of set analysis when using{<Trend='Green' >}Dt).

Regards,

Piyush

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 10:37:00 GMT

Typo error If(Count(Total<Week123> {<Trend={'Green'}>} Dt) >=2, 'Green')

Re: Expression

Tue, 15 Oct 2013 10:45:57 GMT

Hi,

I am aware of that error but it is showing error in set expression.

Regards,

Piyush

Re: Expression

Tue, 15 Oct 2013 10:49:49 GMT

Hi,

I am sending image for clarification.

Re: Expression

rustyfishbones — Tue, 15 Oct 2013 10:51:20 GMT

you are missing the braces around green

it should be {'Green'}

Re: Expression

Tue, 15 Oct 2013 11:21:09 GMT

Hi,

After using Braces it is showing error at first braces.

Regards,

Piyush

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 11:32:30 GMT

Please change you expression to

If(Count(Total<Week123> {<Trend={'Green'}>} Dt) >= 2, 'Green')

Re: Expression

rajni_batra — Tue, 15 Oct 2013 11:34:32 GMT

can u display that error screen?

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 11:50:30 GMT

Hi,

It looks like Trend is not a Field Name its a Expression?

Could you please tell me what expression you are using?

Re: Expression

Tue, 15 Oct 2013 11:56:33 GMT

Hi Celam,

Ya Trend is calculated dimention.

regards,

piyush

Re: Expression

CELAMBARASAN — Tue, 15 Oct 2013 11:58:57 GMT

Could you post that expression?

Re: Expression

Tue, 15 Oct 2013 12:26:00 GMT

hi,

If(status1='Red',R

if(status1='Green,'G'

if(status1='Amber','A')))

this is calculated dimension.

Regards,

Piyush

Re: Expression

Tue, 15 Oct 2013 12:27:38 GMT

Hi,

Its there on same page above.

Regards,

Piyush jain