topic Re: Re: If Statement Issue in QlikView

If Statement Issue

Mon, 31 Mar 2014 13:59:55 GMT

Hi All,

I am trying to implement a Conditional statement based on the following criteria..

I have a list box called Technology. Each technology can be either a Product_Type WRT or TTL. So depending on the technology selected it will be either WRT or TTL. I have some rows in a table that I want to appear depending on whether the technology is WRT or TTL.

I tried using =GetFieldSelections(Product_Type) = 'WRT'

as the conditional experssion - however this does not work unless I display the Produt_Type list box and actively select 'WRT', which I don't want the user to have to do. How can I test which product type group a technology is in to enable the condition?

Many Thanks

John

Re: If Statement Issue

Gysbert_Wassenaar — Mon, 31 Mar 2014 14:02:38 GMT

Try: aggr(only({<Product_Type={'WRT'}>} Technology), Technology)

or: if(Product_Type='WRT',Technology)

Re: If Statement Issue

Anonymous — Mon, 31 Mar 2014 14:05:32 GMT

IF(ISNULL(Only(Product_Type)), condition1, condition2)

Re: If Statement Issue

Mon, 31 Mar 2014 15:36:37 GMT

Hi Michael

I modified yoiur suggestion as follows and it works perfectly

Only (Product_Type)= 'IIC'

Re: Re: If Statement Issue

Tue, 01 Apr 2014 08:21:46 GMT

Hi Gysbert,

Thanks for your suggestion, while I didn't use it in this instance, I did use it in a case where I wanted to show the list price in a table for the Current Forecast without requiring the user to select the Current Forecast..

aggr(only({<ForecastVersion={$(vCurrent_Forecast)}>} [List Price]), [List Price])

However, I don't fully understand how this works, and can't find a good explanation onlline.. Could I ask you to explain the Aggr(Only(... part of the expression please?

Thanks

john

Re: If Statement Issue

arjunkrishnan — Tue, 01 Apr 2014 10:31:45 GMT

if(isnull(Only(Product_Type)), condition1, condition2)