Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

Create a Status

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.?

   

TypeTASKCriticalUrgentNormalMedium
Order ZAA - OS1296001080008640057600
New Server ZAA - OS1296001080008640057600
Server ZAA - OS1296001080008640057600
SolarisZAA - OS57600432002880021600
WareZAA - OS43200360002800021600
OrderZAA - OS (Configure  )1296001080008640057600
New ServerZAA - OS (Configure  )1296001080008640057600
Server ZAA - OS (Configure  )1296001080008640057600
Solaris ZAA - OS (Configure  )57600432002880021600
WareZAA - OS (Configure  )43200360002800021600
Order ZAA - tools1800000
New Server ZAA -   tools1800000
Server ZAA -   tools1800000
Solaris ZAA -   tools1800000
WareZAA -   tools1800000
Tags (2)
1 Solution

Accepted Solutions

Re: Create a Status

May be cross table for those 4 fields as Status?

5 Replies

Re: Create a Status

May be cross table for those 4 fields as Status?

soniasweety
Contributor III

Re: Create a Status

thanks anil.

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

Re: Create a Status

Try like this

Table_name:

Crosstable (Status,Value,2)

LOAD

Type,

TASK,

Critical,

Urgent,

Normal,

Medium

from

table

Re: Create a Status

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

Re: Create a Status

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