topic Re: Qlikview expression in QlikView

Qlikview expression

yogitamehta10 — Wed, 25 Nov 2020 16:16:04 GMT

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

so on..

Re: Qlikview expression

balar025 — Tue, 04 Jul 2017 11:08:47 GMT

hi,

can you please provide sample data and your expected output?

Thanks

Ravi

Re: Qlikview expression

kumarkp412 — Tue, 04 Jul 2017 11:19:17 GMT

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

Re: Qlikview expression

tyagishaila — Tue, 04 Jul 2017 11:21:51 GMT

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

Re: Qlikview expression

yogitamehta10 — Tue, 04 Jul 2017 13:40:32 GMT

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

Re: Qlikview expression

yogitamehta10 — Tue, 04 Jul 2017 13:44:23 GMT

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.