topic Enters into first If condition every time in expression even there is no data? in QlikView

Enters into first If condition every time in expression even there is no data?

jagannalla — Thu, 11 Aug 2011 07:26:54 GMT

Hi,

I want to see in striaght table as below image.

- I tried like this first i had taken Id as dimension and in expression as =if(Count({<Defect ={"A"}>}ID) >0,if(Count({<Single = {"Fail"}>}ID) >0,'Fail',if(Count({<Single = {"Pass"}>}ID) >0,'Pass',if(Count(if(IsNull(Single),0)) >0,'null'))),'-')

- I don't know where i'm doing wrong can anyone help me.

For your reference i'm attaching my qve file.

Enters into first If condition every time in expression even there is no data?

kaushiknsolanki — Thu, 11 Aug 2011 07:51:07 GMT

Hi,

Follow below steps to achieve what you want.

Create a pivot table with dimension as ID and Defect.

Now add expression as

if(Single = '','',if(Single = 'Fail','Fail','Pass'))

Click Finish/Ok

Now drag the Defect Dimension over the Expression.

Regards,

Kaushik Solanki

Enters into first If condition every time in expression even there is no data?

jagannalla — Thu, 11 Aug 2011 08:01:44 GMT

Thanks for your response...

But the think is in my real time requirement. I've two dimensions and different number of expressions say for example Min(x),Max(y)......etc and now i want to include the above post conditon also here....

Enters into first If condition every time in expression even there is no data?

kaushiknsolanki — Thu, 11 Aug 2011 09:02:13 GMT

Hi,

Try this in your real time environment. According to me it should work.

Regards,

Kaushik Solanki

Enters into first If condition every time in expression even there is no data?

jagannalla — Thu, 11 Aug 2011 09:34:50 GMT

Ya i tried in real time environment. But it's not working there also how come it works here without working in small example