topic I need to implement the below excel in QV in QlikView

I need to implement the below excel in QV

Wed, 29 Oct 2014 07:12:57 GMT

Hi I need to implement the below excel in QV.

2 diff conditions in Status field..

1) Sometimes its checking for >

2) Sometime for <

Attached the sample excel.

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 08:00:44 GMT

Hi Sneha,

Based on which condition Status it displaying if you know you can easily impliment it in qlikview.

in the expression tab we have images just clik on that.

if( status>50,'green','red')

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 08:17:49 GMT

Create a Straight Table.

Clik on veiw and on Designer view.

Then place the cursor on the cell you want to apply the logic. Right Clik and select custom format cell.

Here you can give same expression in excel.

Thanks

Pavan

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 08:49:14 GMT

Its checking the Target and value fields and for some fields

Target should be more and for some Target value should be less .... you can see the calculations in the attached excel.

If you can help me with the same

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 08:50:31 GMT

I couldn't find designer view anywhere....if you tell me in detail where I could find it.

Re: Re: I need to implement the below excel in QV

Anonymous — Wed, 29 Oct 2014 08:59:12 GMT

Re: Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 09:04:30 GMT

Hi Venkata ,

I know that part, I want to know how to go forward with the diff calculations of status field... bcz it has 3 different conditions being implemented in the table.

PFA for the excel with calculations.

Thanks.

Re: I need to implement the below excel in QV

Anonymous — Wed, 29 Oct 2014 09:10:00 GMT

No Excel........

Add the Excel file again

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 09:28:40 GMT

HI open the conversation in a new tab , u can find the attachment ...

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 09:42:57 GMT

I have used an expression like -

alt(IF(NewValue>=Type,1,if((fabs(NewTarget-NewValue)/NewTarget)<=0.05,0,-1)))

Also attached the qvw for reference.

Thanks,

Shoubhik.

Re: Re: I need to implement the below excel in QV

Anonymous — Wed, 29 Oct 2014 09:52:56 GMT

Hi Leela ,

Please find the attached application...

This is application will solve u r problem ..

Please check it and revert

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 10:00:41 GMT

But its not working right?

All the status are showing green..

Re: I need to implement the below excel in QV

Anonymous — Wed, 29 Oct 2014 10:01:58 GMT

Hi Leela,

Please check my last reply.........

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 10:31:27 GMT

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 10:32:34 GMT

Hi Venkata ,

We to exactly apply the logic like present in the excel.. where there are 3 different conditions for Status.

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 10:45:01 GMT

Did you tried this??

Re: I need to implement the below excel in QV

Anonymous — Wed, 29 Oct 2014 10:47:03 GMT

Hi,

Can Clearly explain the what are the conditinion ??

for 1st condition wich colour u want and as well as 2 nd & 3rd...

please explain the conditions and related colors also........

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 11:00:11 GMT

HI Pavan

The file you are trying to attach didn't get attached properly.Can you please do it again.

Re: I need to implement the below excel in QV

Wed, 29 Oct 2014 11:05:09 GMT

Hi Venkata,

The status field is finally what I need to calculate like below.

If you could provide me with a way where I could use any rowno conditions or any other way to do the same.

Type	Target	Value	Status
Schedul	98.0%	100%	if ( value >= Target , status=0, 1)
Estimate	99.0%	95%	same as above
Cost	99.0%	99%	same as above
Applications down time	30.0%	40%	if (value <= Target , Status=0 ,1)
Handled	10.0%	0.0%	same as above
Test Design Productivity (TCs/Hr)	7.5	11.0	If ( value > target, status=0 ,1)
Test Execution Productivity (TCs/Hr)	9	6.9	same as above
Test Case Effectiveness (%)	100.0%	100.0%	if ( value >= Target , status=0, 1)

Thanks.

Re: Re: I need to implement the below excel in QV

Anonymous — Wed, 29 Oct 2014 11:12:09 GMT

Hi,

Please find the QVW file In the attachments...