Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Need Help

HI Community,

I have one table like,    I have three fields EmpID, Status and TempDate..

I want to compare with two Months, like 2 variables StartMonth and EndMonth..

Suppose  if i am select May and June,  status wise i have to show data how many changed records.....

EmpIDStatusTempDate
123InProgress5/27/2015
11Resolved5/27/2015
679Resolution Pending5/27/2015
678Opened6/27/2015
123Assigned Owner6/27/2015
11Resolution Pending6/27/2015
11Resolved6/29/2015
13InProgress6/29/2015

Example:

See one particular case..

EmpIDStatusTempDate
123InProgress5/27/2015
123Assigned Owner6/27/2015

Here particular ID wise changed status InProgress to Assigmed Owner..

I want to show  like this......

Capture.JPG

12 Replies
svenkita
Creator II
Creator II

I have attached a sample ... Hope it helps.

I have created a data island of dates and 2 variables which gets populated depending on the selection.

The chart is done using set analysis

jagan
Luminary Alumni
Luminary Alumni

Hi,

If you attach the sample file then it would be easier to understand your data and provide better solution.

Regards,

Jagan.

mohammadkhatimi
Partner - Specialist
Partner - Specialist

Cn u attach the sample file


Regards,

Mohammad

qv_testing
Specialist II
Specialist II
Author

HI Jagan,

PFA,

qv_testing
Specialist II
Specialist II
Author

Please anyone can help me...........

svenkita
Creator II
Creator II

hi

why don't you concatenate both the tables with the following script

May:
LOAD ID,
Status as Status,
Date as date,
StartDate as StartDate,
Duedate as Duedate,
CreationDate as CreationDate,
'May'
as Flag
FROM

(
ooxml, embedded labels, table is May);

Concatenate(May)
//June:
LOAD ID,
Status as Status,
Date as date,
StartDate as StartDate,
Duedate as Duedate,
CreationDate as CreationDate,
'June'
as Flag
FROM

(
ooxml, embedded labels, table is June);

while concatenating the table I have added a static field called flag to separate the data

after loading the data create a bar chart chart with

dimension as Status

expression 1 as count({<Flag={'June'}>ID}

expression2 as Count({<Flag={'May'}>}ID)

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Regards,

Jagan.

qv_testing
Specialist II
Specialist II
Author

Hi Jagan,

But i want change based on selection,

i have all months data, if i am click Feb and Sep..

i want to compare with data based on status changed count....

I have attached sample data in that i have only 2 months May and June....

but i have all months data....

jagan
Luminary Alumni
Luminary Alumni

Hi,

Change the months dynamically by passing the variables.  If you attach sample for all the months then it would be easier to provide the solution.

Regards,

Jagan.