I need to implement the below excel in QV

[#1]

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.

[#2]

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')

[#3]

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

[#4]

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

[#5]

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

[Anonymous]

[#7]

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.

[Anonymous]

No Excel........

Add the Excel file again

[#9]

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

[#10]

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.