Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
sbojovic
New 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
Highlighted
Partner
Partner

Re: Problem- Invalid dimension grouping

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

Highlighted
Partner
Partner

Re: Problem- Invalid dimension grouping

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

Work smarter, not harder

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Problem- Invalid dimension grouping

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

Highlighted

Re: Problem- Invalid dimension grouping

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')
Highlighted
sbojovic
New Contributor

Re: Problem- Invalid dimension grouping

Thank you, that's right.
Highlighted
sbojovic
New Contributor

Re: Problem- Invalid dimension grouping

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

Re: Problem- Invalid dimension grouping

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

Work smarter, not harder

View solution in original post