Please help me in writing expression.

[durgabhavani]

Hi All,

I have three fields as below

empname:
jack
ram
pipe
ross
taylor
elloit

Levels
priority1
priority2

dayscheck
0-10 days
11-15 days
15+ days

I am taking dimesion as employee name in piechart,

My challenge is to write expression:
-> when i click on employee name it needs to check whether it is in priority1 or priority2.
-> if it presents in priority1 or priority2 then it needs to check in dayscheck and gives out put value from dayscheck field?

Please advice me to write an expression

Thanks,
Durga

[#2]

Hi Durga,

How these fields are related means all are same table or from different one?

Please share the Table information?

Regards,

Harsha

[durgabhavani]

Hi Harsha,

Thanks for response!

I have one table name "details" it contains these fields

empname
levels
dayslength

Now i derived dayscheck field using dayslength field as below:

LOAD *,
if(dayslength <= 10, '0-10 Days',
if(dayslength <= 30, '11-15 days',
if(dayslength <= 50, '15+ days', '70+ Days')))) as dayscheck

Now my table contains

empname

levels

dayslength

dayscheck

you know my field values and what is my scenario, please share screenshot or expression, dont share qvw file as i have no access to open.

Waiting for reply!

Thanks,

Durga

[#4]

Hi,

take dim

add calculated dimension

=if(wildmatch(level,'priority1','priority2'),employee)

exp:

=dayscheck

After that go to properties of object > Dimension > select suppress when value is Null

[#5 · Accepted solution]

Hi Durga,

Here Dayscheck field is not having Numeric information. So it is not possible display Dayscheck value in Pie Chart even if we use the Only().

Thanks

Harsha.

[#6]

Hi Durga,

It is possible to display Dayschecck field value in Text Object instead of Pie Chart.

[durgabhavani]

it is showing " No data to display"

[#8]

Try to display in straight table rather than pie it will work,

if still you need to display pie chart then

Dim: if(wildmatch(level,'priority1','priority2'),dayscheck)

use expression : count(employee)

-or-

Dim: dayscheck

use expression : count({level={'priority1','priority2'}}employee)

[durgabhavani]

Thanks you very much for spending lot of time for me! Its woriking.

Durga

[durgabhavani]

Hi harsha,

How to implement only for above conditions.

Thanks,

Durga