topic Re: multiple if in QlikView

multiple if

Fri, 11 Sep 2015 15:37:12 GMT

hello

i am new in qlikview

i have year dimension,

i want to show below expression

if(year=1391,count(if (mid(employee_date,1,4)<=1391 ,personel_code)),

if(year=1392,count(if (mid(employee_date,1,4)<=1392 ,personel_code)),

if(year=1393,count(if (mid(employee_date,1,4)<=1393 ,personel_code))

)))

how can i show this ??

regards

Re: multiple if

sudeepkm — Fri, 11 Sep 2015 15:52:36 GMT

i think you can simplify it at the script level by using an expression like below.

1. Create a new field such as Flag_emp, to create a flag per record where '1' indicates those records where the Year = Year of Employee_date

2. Load Year, ,

if(Year = mid(employee_date,1,4),1,0) as Flag_emp from <data srouce>

3. Use this field in your chart expression like below

Dimension: Year

Expression: count({<Flag_emp={1}>} personal_code)

Re: multiple if

dclark0699 — Fri, 11 Sep 2015 15:52:58 GMT

I think this is likely best solved with a data model change. Could you attach a sample QVW where you are encountering the problem?

Re: multiple if

ecolomer — Fri, 11 Sep 2015 15:53:21 GMT

Can you explain more your question, please?

Re: multiple if

Fri, 11 Sep 2015 16:27:09 GMT

thanks alot

but how to create new field ?

Re: multiple if

Fri, 11 Sep 2015 16:31:53 GMT

i have a bar chart

dimension is year

i want to show number of personal in each year

number of my personal in each year is :

1392=10

1393=12

i want when i select 1393 in listbox , bar cahrt show 22

it means that when i select 1393 , equal no. of personal in 1392 + no. of personal in 1393

Re: multiple if

ecolomer — Fri, 11 Sep 2015 16:36:54 GMT

You can use acumulative option in the chart

Re: multiple if

Anonymous — Fri, 11 Sep 2015 17:05:13 GMT

may be try:

Variable:

vMaxYear = Max(mid(employee_date,1,4))

Set Analysis:

=Count({$< Year ={'<=$(=vMaxYear)'}>} personel_code)