topic Re: flag in QlikView

flag

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

HI All ,

Please find the attachment of the sample excel and qvw file ,

I want to have a field in the script level which will have only those teams names which has "iperformance"

and also a flag which is 1 if team is iperformance .

Thanks

Re: flag

Anonymous — Mon, 27 Mar 2017 04:30:32 GMT

May be you can try below script

LOAD Team,

ID,

loc,

if(WildMatch(Team,'*iPerformance*'),1,0) as flag_isIperf

FROM

(ooxml, embedded labels, table is Iper);

Re: flag

smilingjohn — Mon, 27 Mar 2017 04:39:44 GMT

Thakns Shiva

this will give me a filter , but i want to have a seprate field from the team field which will have only ieprformace in it .

Regards

Re: flag

Anonymous — Mon, 27 Mar 2017 04:45:05 GMT

Didn't get you exactly. Do you want a field like column2 with value **** iperformance as value for those records which has the word in the team name and empty for other records. If yes, Please try something like below,

LOAD Team,

ID,

loc,

if(WildMatch(Team,'*iPerformance*'),1,0) as flag_isIperf,

if(WildMatch(Team,'*iPerformance*'),Team,'') as NewTeam_Field

FROM

(ooxml, embedded labels, table is Iper);

Re: flag

gerry_hdm — Mon, 27 Mar 2017 04:57:58 GMT

Hello John

Grüsse Gerold

Re: flag

gerry_hdm — Mon, 27 Mar 2017 04:59:28 GMT

Here is a example

Gerold

Re: flag

smilingjohn — Mon, 27 Mar 2017 05:06:54 GMT

Thanks shiva this is what i wanted ,

and one more thing shiva , when i creat the filter for iPerformance , i have to show it like thi in the frnt end , as shwon in the screenshot.

Wheni click in the check box it should show me all the value re;ated to iperformance ,

I tried to that but when i take filet i have 0 and 1 , 'where as the requirement is to show a check box filter , if we click on the check box it is like selecting 1 .

Re: flag

Anonymous — Mon, 27 Mar 2017 05:33:54 GMT

May be like this