topic Re: Where and if conditional in QlikView

Where and if conditional

Wed, 29 May 2013 10:15:12 GMT

Hello

I want to do I do not know exactly the format expressions clause is as follows, but I'd appreciate if you can help.

=Count({<YAPILDI_MI=num(1)> (if (SON_FIILI_DURUM='KAPALI',GVG_UID))})

Thank you

er_mohit — Wed, 29 May 2013 10:24:19 GMT

Try this

Count({<YAPILDI_MI={1},SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)

er_mohit — Wed, 29 May 2013 10:42:40 GMT

try this one also

Count({<YAPILDI_MI={1},GVG_UID=p({< SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)>}distinct GVG_UID)

Wed, 29 May 2013 10:42:43 GMT

Thank You but, returned zero results

Wed, 29 May 2013 10:47:46 GMT

zero again

Wed, 29 May 2013 10:52:19 GMT

try this

count({<YAPILDI_MI=, SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)

then select any data of YAPILDI_MI field.

Wed, 29 May 2013 11:05:49 GMT

In the first trial, but it did not

Count({<YAPILDI_MI={1},SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)

er_mohit — Wed, 29 May 2013 11:07:42 GMT

Hiiii

I think in your field YAPILDI_MI is not one that's why it gives zero or try to check KAPALI field value in SON_FIILI_DURUM

If its right then try this one first to check value is coming or not

try this code

Count({<SON_FIILI_DURUM={'KAPALI'}>}GVG_UID) if data not comes then check fieldvalue if comes then

try the value of YAPILDI_MI={1} like this

Count({<YAPILDI_MI={1}>}distinct GVG_UID) if data comes then try above mentioned code

if not come then tell me where you got error..

Wed, 29 May 2013 12:12:41 GMT

Thank you solved the problem YAPILDI_MI changed column