topic Re: Need Help in QlikView

Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 03:24:28 GMT

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

EmpID	Status	TempDate
123	InProgress	5/27/2015
11	Resolved	5/27/2015
679	Resolution Pending	5/27/2015
678	Opened	6/27/2015
123	Assigned Owner	6/27/2015
11	Resolution Pending	6/27/2015
11	Resolved	6/29/2015
13	InProgress	6/29/2015

Example:

See one particular case..

EmpID	Status	TempDate
123	InProgress	5/27/2015
123	Assigned Owner	6/27/2015

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

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

Re: Need Help

svenkita — Mon, 13 Jul 2015 04:10:57 GMT

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

Re: Need Help

jagan — Mon, 13 Jul 2015 04:18:52 GMT

Hi,

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

Regards,

Jagan.

Re: Need Help

mohammadkhatimi — Mon, 13 Jul 2015 04:34:09 GMT

Cn u attach the sample file

Regards,

Mohammad

Re: Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 05:16:09 GMT

HI Jagan,

PFA,

Re: Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 06:53:38 GMT

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

Re: Need Help

svenkita — Mon, 13 Jul 2015 07:31:37 GMT

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)

Re: Need Help

jagan — Mon, 13 Jul 2015 07:51:44 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 11:06:17 GMT

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

Re: Need Help

jagan — Mon, 13 Jul 2015 11:10:49 GMT

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.

Re: Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 11:28:59 GMT

PFA,

I have attached 5 months data...

Re: Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 15:39:43 GMT

Hi Jagan,

Have you Understand my scenario...

Let me explain again....

I have ID, Status and Date these are my fields...

Suppose i have created 2 variables.. these variables compare with status..

Suppose if i am select June and May..

In my June Month status Resolved, May Month status it has Changed..

Here one particular case..

See here Resolved June status and May status

Assigned Owner (This count 1)

Resolved (this Count 1)

Resolution Pending (This count 2) Total count 4

Actually i have attached Images i.e hard coded for June and May month......

I want to compare Month to Month, if i am select Dec and Jan i want to compare based on selection..

Hope You understand.....

Re: Need Help

Nagaraju_KCS — Mon, 13 Jul 2015 15:40:59 GMT

Hi Venkita,

Thanks for response..

I want to change based on selection....

I have all months data...