topic Help with expression (if condition) in QlikView

Help with expression (if condition)

Thu, 07 Jun 2012 04:33:26 GMT

Hi Friends,

I have a 'calender' table having years from 1900 to 2999.

This calender table is joined with another table (Say A) by a key (Say A_key)

This table A is joined to my fact table (Say B) by a key (Say B_key) --so basically its a snow-flake kind of connection to calender table.

Table B contains information related to candidate responses to a set of questions, and main metrics is sum(candidate_response)

Now the requirement is, as a filter, we need to show the "Year"

When i simply add a list box for year, it shows all the values from 1900 to 2999

I dont want this. I want to show in the "Year" filter, only those values which have sum(candidate_response) >0 (or simply put..those Years which are relevant and has informative data associated with it)

The expression which i tried in "Year" listbox was this =if(sum({<Year>}candidate_response)>0,Year)

This did not work. Can any experienced guys help me here.

Thanks,

Vishnu

Help with expression (if condition)

Thu, 07 Jun 2012 05:27:07 GMT

Hi this seems to be a simple stuff. Just waiting for help from you

The expression =if(sum({<Year>}candidate_response)>0,Year) is not working

Re: Help with expression (if condition)

muniyandi — Thu, 07 Jun 2012 05:28:54 GMT

Hi Vishnu,

just wrote inline use same name.

This Attachment file is help for you.

Muni

Help with expression (if condition)

Thu, 07 Jun 2012 05:29:54 GMT

Do you need to have all those years in your Calender table?

If not, filter the unwanted values as part of your script.

To do this, create the Calendar table from Table A, or use Where Exists on the Year.

Help with expression (if condition)

sivarajs — Thu, 07 Jun 2012 07:05:49 GMT

using set inside if condition wont work, try without using it

Help with expression (if condition)

perumal_41 — Thu, 07 Jun 2012 08:48:18 GMT

Hi ,

if(sum({<Year=>}candidate_response)>0,Year) try this Expression .if not working ,please upload sample file

for reference .

Regards

Perumal A