Create a Status

[soniasweety]

Hi all,

I have a data like below.for each type one task and the satus time  ,

req: how can create as status field with 1critical,2urgent,3normal,4medium.?

Type	TASK	Critical	Urgent	Normal	Medium
Order	ZAA - OS	129600	108000	86400	57600
New Server	ZAA - OS	129600	108000	86400	57600
Server	ZAA - OS	129600	108000	86400	57600
Solaris	ZAA - OS	57600	43200	28800	21600
Ware	ZAA - OS	43200	36000	28000	21600
Order	ZAA - OS (Configure  )	129600	108000	86400	57600
New Server	ZAA - OS (Configure  )	129600	108000	86400	57600
Server	ZAA - OS (Configure  )	129600	108000	86400	57600
Solaris	ZAA - OS (Configure  )	57600	43200	28800	21600
Ware	ZAA - OS (Configure  )	43200	36000	28000	21600
Order	ZAA - tools	1800	0	0	0
New Server	ZAA -   tools	1800	0	0	0
Server	ZAA -   tools	1800	0	0	0
Solaris	ZAA -   tools	1800	0	0	0
Ware	ZAA -   tools	1800	0	0	0

[Anil_Babu_Samineni · Accepted solution]

May be cross table for those 4 fields as Status?

[soniasweety]

thanks anil.

but cross table is not working in Qliksense same it is working in qlikview

[avinashelite]

Try like this

Table_name:

Crosstable (Status,Value,2)

LOAD

Type,

TASK,

Critical,

Urgent,

Normal,

Medium

from

table

[Anil_Babu_Samineni]

Try to paste script as transpose may not available while load in Qliksense. Then reload and check. I assume, Qliksense must work because all script qlikview functions working in qliksense as well

[Peter_Cammaert]

You are posting in a forum called "New to QlikView", and as a result you'll probably get QlikView-oriented replies.

Please move your question to a Qlik Sense forum by following the instructions listed here: QlikCommunity Tip: How to move your discussion thread