Skip to Content
avatar image
Former Member

Webi Crosstab #multivalue

Hello

I have a series of True / False expressions in 'check' columns.

Then I have a 'result' column that returns Answer A,B,C...etc...

This result column is variable made up of if statements using the 'check' columns.

When I try to crosstab, pivot the result against per 'team'

Team (rows) , Result (column) - I get the #multiselect error in the column.


Why doesn't Webi simply layout all of the 'result' answers across the columns?

Thanks!

multi.png (8.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 07, 2017 at 02:10 PM

    check if your variable is measure or dimension.If measure then convert to dimension and see

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Done that.

      Created a dimension = measure and used this in the cross tab, refreshed...same error.

  • Sep 08, 2017 at 07:00 AM

    Hi,

    setup your table on the lowest level (create an unique key in your table)...let the variable work on that, via breaks you can aggregate the table like the layout you desire

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Koen Hesters

      I have 3 columns

      Team Status ID

      Team1 Leave 11111

      Team1 Check 22222

      Team2 Check 33333

      Team2 Overdue 444444

      I simply would like to have a pivot of this

      Team on the left - OK

      Status on the top - this is what I can't get without a multiselect.

      Cound of ID - OK