Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HOW TO SOLVE ERROR IN EXPRESSION IN TEXT BOX?

HI,

I WROTE EXPREESSION IN TEXT BOX IT SHOW ERROR IN THAT BOX HOW TO REMOVE ERROR IN MY TEXT BOX.I DO NOT KNOW HOW TO REMOVE ERROR IN THAT EXPRESSION, PLEASE TELL ME OUT HOW TO SOLVE THIS PROBLEM.

I ATTACHED SNIPPING FILE BELOW THIS BOX.

  THANK YOU,

REGARDS:

MADHU

=if(ID=1,'qmem://Image name/Badminton820PRed',

If(ID=2,'qmem://Image name/Badminton940V',

If(ID=3,'qmem://Image name/Badminton Bag 800',

if(ID=4,'qmem://Image name/Artengo BL800Blue',

If(ID=5,'qmem://Image name/Artengo BL800',

if(ID=6,'qmem://Image name/FKT 580 BLACK',

if(ID=7,'qmem://Image name/FKT 580 BLUE',

If(ID=8,'qmem://Image name/FIGHTING GLOVE 790',

If(ID=9,'qmem://Image name/REDMITT',

If(ID=10,'qmem://Image name/FKT180REDGLOVES',

if(ID=11,'qmem://Image name/FKT180 WHITE',

if(ID=12,'qmem://Image name/AERO GEL GLOVES',

If(ID=13,'qmem://Image name/GDC 290 GLOVES',

if(ID=14,'qmem://Image name/KARATE FOOT GUARD',

If(ID=15,'qmem://Image name/KARATE FOOT PRO',

If(ID=16,'qmem://Image name/SHIN FOOT GUARD',

If(ID=17,'qmem://Image name/JUNIOR HELMET PU',

If(ID=18,'qmem://Image name/SHIN GUARD',

If(ID=19,'qmem://Image name/FOREARM GUARD',

If(ID=20,'qmem://Image name/TEETH PROTECT',

If(ID=21,'qmem://Image name/KUNG FU KIMONO',

If(ID=22,'qmem://Image name/HIROSAKI 400',

If(ID=23,'qmem://Image name/DO BOK 400',

If(ID=24,'qmem://Image name/HIROSAKI 50',

If(ID=25,'qmem://Image name/OKAYAMA 400',

If(ID=26,'qmem://Image name/DO BOK 50',

If(ID=27,'qmem://Image name/SHORT GRAPPLING',

If(ID=28,'qmem://Image name/KUNG FU SHOES',

If(ID=29,'qmem://Image name/CEINTURE KARATE 2 5M',

if(ID=30,'qmem://Image name/CEINTURE JUDO UNIES 2 5M',

If(ID=31,'qmem://Image name/CEINTURE JUDO BICOLORE 2 5 M',

If(ID=32,'qmem://Image name/CEINTURE BICOLORE 2 5M',

If(ID=33,'qmem://Image name/TB 1200 BLACK',

If(ID=34,'qmem://Image name/DOMYOS PUNCH BAG TB 580',

If(ID=35,'qmem://Image name/DOMYOS PUNCH BAG TB 390',

If(ID=36,'qmem://Image name/PUNCH BALL GLOVES',

If(ID=37,'qmem://Image name/FLAT SHIELD',

If(ID=38,'qmem://Image name/PUNCHING BAG JUNIOR', 

If(ID=39,'qmem://Image name/PUNCHING BAG JR',

If(ID=40,'qmem://Image name/PUNCH BAG HOOK',

If(ID=41,'qmem://Image name/JYO 1M28 STICK',

If(ID=42,'qmem://Image name/WOODEN WEPON BAG',

If(ID=43,'qmem://Image name/BOOKEN ADULT',

If(ID=44,'qmem://Image name/TANTO WOOD',

If(ID=45,'qmem://Image name/PLASTIC KNIFE BLACK',

If(ID=46,'qmem://Image name/GAIN TRAINER BLACK',

If(ID=47,'qmem://Image name/ABDO GAIN',

If(ID=48,'qmem://Image name/AB 110',

If(ID=49,'qmem://Image name/AB WHEEL',

If(ID=50,'qmem://Image name/PPE 370 WEIGHT RACKS',

If(ID=51,'qmem://Image name/BT 500',

If(ID=52,'qmem://Image name/TRAINING STRAP',

IF(ID=53,'qmem://Image name/BT 200 PULL UP BAR',

If(ID=54,'qmem://Image name/TRICEPS THREADED BAR',

IF(ID=55,'qmem://Image name/LATTISSIMUS PULL DOWN BAR',

If(ID=56,'qmem://Image name/PULL ROPE',

IF(ID=57,'qmem://Image name/MEDIUMHAND GRIPX2',

If(ID=58,'qmem://Image name/HARD HAND GRIP',

If(ID=59,'qmem://Image name/EGG PRESS',

If(ID=60,'qmem://Image name/KIT 50 KG',

If(ID=61,'qmem://Image name/KIT 30 KGS',

If(ID=62,'qmem://Image name/SUITCASE KIT 20KG',

If(ID=63,'qmem://Image name/BLACK BARBEL SET 10 KG',

If(ID=64,'qmem://Image name/BARRE OLYMPIQUE',

If(ID=65,'qmem://Image name/TRAINING STRAP',

IF(ID=66,'qmem://Image name/TRICEPS THREADED BAR',

If(ID=67,'qmem://Image name/2.0M BAR',

IF(ID=68,'qmem://Image name/1.75M BAR',

If(ID=69,'qmem://Image name/DOMYOS 1.55M BAR',

If(ID=70,'qmem://Image name/DOMYOS CURLY BAR',

If(ID=71,'qmem://Image name/1.2MBAR',

IF(ID=72,'qmem://Image name/WEIGHLIFT BELT WIDE',

IF(ID=73,'qmem://Image name/BODY POWER',

IF(ID=74,'qmem://Image name/0.38MM BAR',

If(ID=75,'qmem://Image name/SQUAT PAD',

IF(ID=76,'qmem://Image name/FITNESS BELT VELCRO',

If(ID=77,'qmem://Image name/GYM BALL',

If(ID=78,'qmem://Image name/65 CM GYM BALL',

If(ID=79,'qmem://Image name/GYM BALL 55 CM',

IF(ID=80,'qmem://Image name/GYM BALL PUMP',

If(ID=81,'qmem://Image name/HAND FOOT AIR PUMP',

IF(ID=82,'qmem://Image name/FITNESS MAT COMFORT',

IF(ID=83,'qmem://Image name/TG 100 MATS',

If(ID=84,'qmem://Image name/HOME GYM 60 4',

If(ID=85,'qmem://Image name/ESSENTIAL 420 BLUE TRAMPOLINE',

IF(ID=86,'qmem://Image name/ESSENTIAL 365 TRAMPOLINE',

If(ID=87,'qmem://Image name/ESSENTIAL 240 TRAMPOLINE',

IF(ID=88,'qmem://Image name/MT 200',

IF(ID=89,'qmem://Image name/BM 490',

IF(ID=90,'qmem://Image name/RBR 910',

If(ID=91,'qmem://Image name/BM 210',

If(ID=92,'qmem://Image name/BM 120',

If(ID=93,'qmem://Image name/BA 220',

If(ID=94,'qmem://Image name/BA 120',

If(ID=95,'qmem://Image name/DISQUE CAOUTHOUC 20 KG',

If(ID=96,'qmem://Image name/DISQUE CAOUTHOUC 10 KG',

IF(ID=97,'qmem://Image name/FOAM DUMBELL 2 *2.5 KG',

IF(ID=98,'qmem://Image name/KETTLEBELL16KG',

If(ID=99,'qmem://Image name/KETTLEBELL12KG',

IF(ID=100,'qmem://Image name/OLYMPIC STOP DISC'))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

9 Replies
MK_QSL
MVP
MVP

Looks like no error in your expression but QliKView have limit of 99 If in a single expression..

But I am not 100% sure, so would love to wait comments from other members...

m_woolf
Master II
Master II

Looks like Manesh is correct.

When I paste the expression into a textbox, I get:

"Error: Error in expression. Too complex, more than 100 levels nesting"

marcus_sommer

Generally are such many nested if-loops not a good way. Better would be to have a matching-table within the data-model or to use a pick(match()) like this:

'qmem://Image name/' & pick(match(ID, 1, 2, 3, ...),

     'Badminton820PRed', 'Badminton940V', 'Badminton Bag 800', ...)

- Marcus

AbhijitBansode
Specialist
Specialist

use WildMatch  function with Peek function for such nested if else.

eg.

Pick

(

     (Wildmatch,ColumnName,'one','two'),

     1,

     2

)

I will return 2 when ColumnName is two and 1 when ColumnName is one

Not applicable
Author

thank you

MK_QSL
MVP
MVP

Kindly close the thread by selecting correct/helpful answer...

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

I think you mean Pick. The other Peek is an interrecord function that can only be used in script. Also, in this case pick(match()) will be okay because you're searching exact coincidences (numbers). When, you're searching parts of a string or using wildcards, definitely is good option is to use Wildmatch(),


I don't know if match/wildmatch has a limit of values, but it can be quite faster than a nested if specially with big volumes of data. Also you can make an inline table with the relationship of ID and the image and pass the values through a variable in the pick(match()) function:


pick(match(Field,$(VariableContainingtheIDs) ),$(VariableWiththeImagePath) )

regards

Not applicable
Author

thank you Marcus Sommer it works

regards:

madhu

AbhijitBansode
Specialist
Specialist

It was a typo, I meant Pick function.

thanks for correction.