Qlikview expression

[yogitamehta10]

Hi all,

I have a expression  I want those assessment which are greater then 7  as in values and  for criteria P10.then my value should be y otherwise n.

if(Criteria No='P10' and Assessment >7,'Yes','No'),

but its not showing everything no for all the P10. , when I m selecting P10 from list box then it showing values . I want this to filter  for a particular expression automatically for criteria P10 for particular iD.

for each Id  I have  P1 to P10 then for every id  and for every P I have some Y ,N value.

so now I have to match all the values of  P10  and P8 for all the ID.

columns are

ID P  value

1 P1 Y

1 P3  N

1 P8 Y

2.

so on..

[balar025]

hi,

can you please provide sample data and your expected output?

Thanks

Ravi

[kumarkp412]

Hi Yogita,

Could you please check that,

how many no of id are available in P10  and that all id are available when you include  the Assement > 7.

It may be the possible some of the id which assement value is less than 7.

If possible can you share the sample of your issue.It could help to provide the exact solution.

Thanks

Kumar KVP

[tyagishaila]

share sample app with expected result to make it more clear.

[yogitamehta10]

ID	CriteriaNo	Brand	value	P11	p10
			4	No	NO
4008429037894	P10	Dre	4	No	NO
3065890123878	P10	Pe	4	No	Yes
3065890123892	P10	Pe	4	No	NO
3065890123915	P10	Pe	4	No	NO
3065890124035	P10	Pe	4	No	Yes
5010394001441	P10	Pe	4	No	Yes
5010394984577	P10	Pe	4	No	Yes
5010394984584	P10	Pe	4	No	NO
5010394986052	P10	Pe	4	No	Yes
5010394986076	P10	Pe	4	No	NO
5998749105214	P10	Pe	4	No	Yes
5998749109113	P10	Pe	4	No	Yes
5998749110027	P10	Pe	4	No	NO
5998749110409	P10	Pe	4	No	Yes
5998749115480	P10	Pe	4	No	NO
8410136001574	P10	Pe	4	No	NO
8410136001659	P10	Pe	4	No	NO
3065890123878	P11	Pe	4	No	NO
3065890123892	P11	Pe	4	No	NO

[yogitamehta10]

output I need  from this is

for every brand for each id there are multiple  criteria like P10 and P11.

so I have values of P10 and P11 criteria for  each id  that falls under this criteria and which belong to particular brand.

I want to see  according to brand  for each Id  I have some values for P10,P11.

so if this id pass in both the criteria then it should be yes otherwise  no.