topic issue on if condition in QlikView

issue on if condition

Wed, 25 Nov 2020 16:16:04 GMT

if( 1.1 smaple or 1.2 sample or 1.3 sample or 1.4 sample or 1.5 sample or 1.6 sample or 1.7..........2.9 ='on track','G',

if( 1.1 Review or 1.2 Review or 1.3 Review or 1.4 Review or 1.5 Review or 1.6 Review or 1.7..........2.9 ='Hold','Y',

if( 1.1 regin or 1.2 regin or 1.3 regin or 1.4 regin or 1.5 regin or 1.6 regin or 1.7..........2.9 ='Progress','B',)))

like above i need to write 10 more lines like that please correct me on my if condition

Thanks

ziadm — Tue, 21 Jun 2016 19:39:57 GMT

The syntax should be

if( [1.1 smaple] ='on track' or [1.2 sample] ='on track' ...........,'G',if())

This is a lengthy if condition and could be written in a better if you share a sample data

Tue, 21 Jun 2016 19:52:14 GMT

i tried like that but still showing wrong results

ziadm — Tue, 21 Jun 2016 20:16:36 GMT

Please share a sample data .. There are many better ways than if statement and more efficient

Tue, 21 Jun 2016 20:50:56 GMT

please find my Sample docs

if( 1.1 smaple or 1.2 sample or 1.3 sample or 1.4 sample or 1.5 sample or 1.6 sample or 1.7..........2.9 ='on track','G',

if( 1.1 Review or 1.2 Review or 1.3 Review or 1.4 Review or 1.5 Review or 1.6 Review or 1.7..........2.9 ='Hold','Y',

if( 1.1 regin or 1.2 regin or 1.3 regin or 1.4 regin or 1.5 regin or 1.6 regin or 1.7..........2.9 ='Progress','B',))

sunny_talwar — Tue, 21 Jun 2016 21:03:15 GMT

What are you trying to achieve?

Tue, 21 Jun 2016 21:53:30 GMT

According to my sample data my output shown in image

if( 1.1 smaple or 1.2 sample or 1.3 sample or 1.4 sample or 1.5 sample or 1.6 sample ='on track','G',

if( 1.1 Review or 1.2 Review or 1.3 Review or 1.4 Review or 1.5 Review or 1.6 Review ='Hold','Y',

if( 1.1 regin or 1.2 regin or 1.3 regin or 1.4 regin or 1.5 regin or 1.6 regin ='Progress','R',))

Thanks,

sunny_talwar — Tue, 21 Jun 2016 22:05:10 GMT

Not sure why you don't want to use CrossTable, but see this is what i get using crosstable load

varshavig12 — Wed, 22 Jun 2016 03:56:07 GMT

Is this okay ?

Expression for 1.1 Sample:

=if([1.1 Sample]='on track','G',

if([1.1 Sample]='on Hold','Y',

if([1.1 Sample]='Progress','R')))

PS: I still think Cross table is a better option as suggested by stalwar1‌