topic Re: Category wise disctribution. in QlikView

How to show category wise distribution.

dhananjay_capge — Mon, 03 Apr 2017 10:46:05 GMT

Test

Anonymous — Mon, 03 Apr 2017 10:51:14 GMT

Dhanunjay,Can you provide sample data??

Kushal_Chawda — Mon, 03 Apr 2017 12:00:04 GMT

=if(wildmatch(lower([Error Text]),'*you can''t use business partner*'),'Invalid Business Partner',

if(wildmatch(lower([Error Text]),'*owner is inactive*'),'Owner is Inactive',

if(wildmatch(lower([Error Text]),'*exception:*'),'Exception in c4c',

if(wildmatch(lower([Error Text]),'*please enter an existing product id*'),'Missing Technology')))) as Category

Edit: syntax error is corrected

Anonymous — Mon, 03 Apr 2017 12:31:56 GMT

Try this

if(WildMatch(Lower([Error Text]),'*business partner*'),'Invalid Business Partner',

if(WildMatch(Lower([Error Text]),'*Owner is Inactive*'),'Owner is Inactive',

if(WildMatch(lower([Error Text]),'*Exception:*'),'Exception in c4c',

if(WildMatch(Lower([Error Text]),'*Please enter an existing product ID*'),'Missing technology'))))

sunny_talwar — Mon, 03 Apr 2017 13:02:17 GMT

Jakhas