topic Re: Please help me in writing expression. in QlikView

Please help me in writing expression.

durgabhavani — Wed, 25 Mar 2015 09:10:23 GMT

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

Re: Please help me in writing expression.

Wed, 25 Mar 2015 09:14:19 GMT

Hi Durga,

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

Please share the Table information?

Regards,

Harsha

Re: Please help me in writing expression.

durgabhavani — Wed, 25 Mar 2015 09:24:02 GMT

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

Re: Please help me in writing expression.

Wed, 25 Mar 2015 10:03:49 GMT

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

Re: Please help me in writing expression.

Wed, 25 Mar 2015 10:08:26 GMT

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.

Re: Please help me in writing expression.

Wed, 25 Mar 2015 10:09:53 GMT

Hi Durga,

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

Re: Please help me in writing expression.

durgabhavani — Wed, 25 Mar 2015 10:10:44 GMT

it is showing " No data to display"

Re: Please help me in writing expression.

Wed, 25 Mar 2015 10:21:55 GMT

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)

Re: Please help me in writing expression.

durgabhavani — Wed, 25 Mar 2015 10:33:18 GMT

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

Durga

Re: Please help me in writing expression.

durgabhavani — Wed, 25 Mar 2015 12:01:11 GMT

Hi harsha,

How to implement only for above conditions.

Thanks,

Durga