topic Re: How split a table in QlikView

How split a table

Anonymous — Thu, 14 Nov 2013 11:42:33 GMT

Dear all,

I've ta table with all my maintenance tickets.

I need to create two straight tables, the first one for the new tickets and the second one for the others, like these.

New tickets Status Others Status

bug_id bug_description NEW bug_id bug_description other status codes

Do I've to create two different tables in my script ?

I'm sorry but I'm a bit confused

Help please

tresB — Thu, 14 Nov 2013 11:43:55 GMT

Not really. You can get it done in several ways in the front-end.

Using

-Calculated dimension -

For Status dimension use expression like: If(Status='NEW', Status) // and in the dimension tab check 'Supress When Value is Null'

And for second table : If(Status<>'NEW', Status)

-Set Analysis

kaushiknsolanki — Thu, 14 Nov 2013 11:45:38 GMT

Hi,

You dont need to do anything in script.

All you have to do is create two straight table.

1. with dimension as Bug_ID

and Expression as Only({<Status = {"*New*"}>}Status )

2 with dimension as Bug_ID

and Expression as only({<Status -= {"*New*"}>}Status )

Regards,

Kaushik Solanki

israrkhan — Thu, 14 Nov 2013 11:48:18 GMT

as tresesco said, dont need to split tables, load as one table.

and easily can do with set analysis, calculated dimensions are slower in performance, if you have large data set.

Thu, 14 Nov 2013 11:48:53 GMT

Hi,

If client required separate tables create a two straight tables with the condition of new and old.

Regrads,

Santhosh G

Anonymous — Thu, 14 Nov 2013 13:47:49 GMT

Thanks very much !!!