Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sbojovic
Contributor
Contributor

Problem- Invalid dimension grouping

if(WildMatch(Kategorija,'*reprezentacija*'),'Zakonski neodbitno',If(WildMatch(Kategorija,'*putnicka vozila*'),'Zakonski neodbitno',if(WildMatch(Kategorija,'*Uvoz robe*'),'Ostalo',if(WildMatch(Kategorija,'*garancija*'),'Ostalo','Potencijalno odbitno')))

2 Solutions

Accepted Solutions
JordyWegman
Partner
Partner

Hi Sbojivic,

It looks like you are missing a ')' at the end for closing your first if statement.

If(WildMatch(Kategorija,'*reprezentacija*'),'Zakonski neodbitno',
    If(WildMatch(Kategorija,'*putnicka vozila*'),'Zakonski neodbitno',
        If(WildMatch(Kategorija,'*Uvoz robe*'),'Ostalo',
            If(WildMatch(Kategorija,'*garancija*'),'Ostalo','Potencijalno odbitno'
             )
        )
     )
)

Jordy

Climber

Work smarter, not harder

View solution in original post

JordyWegman
Partner
Partner

If your problem is solved, please mark it as solved.

Work smarter, not harder

View solution in original post

5 Replies
JordyWegman
Partner
Partner

Hi Sbojivic,

It looks like you are missing a ')' at the end for closing your first if statement.

If(WildMatch(Kategorija,'*reprezentacija*'),'Zakonski neodbitno',
    If(WildMatch(Kategorija,'*putnicka vozila*'),'Zakonski neodbitno',
        If(WildMatch(Kategorija,'*Uvoz robe*'),'Ostalo',
            If(WildMatch(Kategorija,'*garancija*'),'Ostalo','Potencijalno odbitno'
             )
        )
     )
)

Jordy

Climber

Work smarter, not harder

View solution in original post

sunny_talwar

Why don't you simplify it to this

Pick(WildMatch(Kategorija,'*reprezentacija*', '*putnicka vozila*', '*Uvoz robe*', '*garancija*') + 1,
'Potencijalno odbitno', 'Zakonski neodbitno', 'Zakonski neodbitno', 'Ostalo', 'Ostalo')
sbojovic
Contributor
Contributor
Author

Thank you, that's right.
sbojovic
Contributor
Contributor
Author

Thank you for your suggestion, I'll try that way as well.
JordyWegman
Partner
Partner

If your problem is solved, please mark it as solved.

Work smarter, not harder

View solution in original post