topic if for dynamic variable in QlikView

if for dynamic variable

Wed, 20 Jul 2011 11:22:07 GMT

Hello,

I have 2 questions please?

1) I need to check a date against multiple values availbale in other resident table, and if the value is TRUE then set certain value.

for example

I have in table the folllowing fields ("30/11/2010","18/07/2009","10/03/2011",...etc) , and this table is built using max while uploading the script as a resident table

within the same script, I need to check if the loaded date of another table is part of this resuident table to set a YearEnd value as 1

(i.e. IF date(mydate) = $dates avauilable in the table, 1, 0) as YearEnd

so, how can I do this?

within the expression of a chart, how can I check if a selection is NULL or was selected ? for example I have drill down dimension group, s in case level 1 is clicked I need to show the sum of value-A, if level 2 then show sum of value-B ,.... and so on

many thanks

regards,

if for dynamic variable

rahulgupta — Wed, 20 Jul 2011 11:30:53 GMT

Hey Hi,

For your 1st issue: Use Exists() Function at the script level.

2nd Issue: Use the GetSelectedCount(Field_Name) in the Chart Expression

Hope this helps

Regards

if for dynamic variable

Wed, 20 Jul 2011 13:09:42 GMT

the exists functionality didn't work as I am getting false value as return status

below are my scripts

maxYear:
LOAD
max(c_date) as myYearEnd
FROM
[daily_close.qvd]
(qvd) group by year(c_date);

myDate:

Load

c_date,

idx,

if (exists(myYearEnd,c_date), idx, 0) as YearEndidx,

from

[daily_close.qvd]

(qvd) ;