topic Re: Conditional Expression in QlikView

Conditional Expression

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

Dear Community,

i made concatenated Column on my load script

'01' & TOWN & LOCALITYCODE & SLOCALITYCODE & POP & DISTRIBUTORCODE as DISTRIBUTORCODE_SHOP

in the field DISTRIBUTORCODE i have multiple shop name against same TOWN & LOCALITYCODE & SLOCALITYCODE & POP

but from presentation layer i want to make a conditional variable that work on base of selection if i select in self service BI from field on he basis of TOWN,LOCALITYCODE ,POP it shows unique value on the base of same TOWN,LOCALITYCODE ,POP but if i select DISTRIBUTORCODE its shows all shops against this DISTRIBUTORCODE.

Note : DISTRIBUTORCODE have multiple shops against TOWN,LOCALITYCODE ,POP.

Need your help on this above scenario.

Regards

Noman khan

Re: Conditional Expression

Kushal_Chawda — Mon, 09 May 2016 06:04:18 GMT

Can you show some sample data and expected output for that?

Re: Conditional Expression

sunny_talwar — Mon, 09 May 2016 06:04:31 GMT

Not sure I completely follow your requirement. Would you be able to share a sample with the expected output?

Re: Conditional Expression

avinashelite — Mon, 09 May 2016 06:08:54 GMT

Agreed with Sunny and Kushal

please share the sample data and required output format otherwise it will be hard to guess the requirement

Re: Conditional Expression

noman212 — Mon, 09 May 2016 07:01:23 GMT

=if(SubStringCount(Concat(Distinct DISTRIBUTORCODE), DISTRIBUTORCODE)>0, SHOPCODE, left(SHOPCODE,len(SHOPCODE)-right(SHOPCODE,4)))

please help me to correct this expression

if i select distributor code it display complete shop code like

01T000021350080300112

else

len - 4

01T00002135008030

Re: Conditional Expression

noman212 — Mon, 09 May 2016 07:20:55 GMT

Please find the attached sample file

Re: Conditional Expression

tamilarasu — Mon, 09 May 2016 08:07:19 GMT

Like attached.?