how to avoid if condition in Dashboard

[Anonymous]

Hi..

I have formula like =count({$<DISPOSITION={"XA"}>} if(LASTMENUACCESSED=MENUID,MENUID,null()) ) in dash board..

but i have to avoid if(LASTMENUACCESSED=MENUID,MENUID,null()) in dashboard.

Please help me..

please find following attachment..

Thanks,

[jagan]

Hi,

Is LASTMENUACCESSED, MENUID are in the same table?  Then try like this

LOAD

*,

If(LASTMENUACCESSED=MENUID, 1, 0) AS Flag

FROM DataSource;

Now use below expression

=count({$<DISPOSITION={"XA"}, Flag={1}>} MENUID)

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi..

Jagan Thanks for your reply..

Menuid and lastmenuaccessed are in Different tables...

Thanks..

[amit_saini]

Chandini,

Check this:

Re: how to avoid nested if

Thanks,
AS

[jagan]

Hi,

If possible bring both this columns into same table and arrive the flag?

Regards,

Jagan.

[Anonymous]

Hi jagan..

What my exact need is my formula is

=count({$<DISPOSITION={"XA"}>} if(LASTMENUACCESSED=MENUID,MENUID,null()) )

in this if(LASTMENUACCESSED=MENUID,MENUID,null()) .i have to avoid if condition statement into  set analysis formula..

means entire formula contains only set analysis formulas not if conditions..

please help me...

Thanks..

[perumal_41]

Hi,

Try below expression. you can avoid if  condition through p() function.

=count({$<DISPOSITION={"XA"},MENUID=p(LASTMENUACCESSED)>} MENUID)

[sujeetsingh]

Chandani,

Better you follow the concept of Flag suggested by Jagan.

Derieve Flag for the conditions in script and then call them in UI where needed.

[Anonymous]

Hi Jagan..

Can you help me entire formula to set analysis related formula..

THAMKS,

[jagan]

Hi,

Attach some sample file then it would be easier to give solution.

Regards,

Jagan.