Discussion Board for collaboration on QlikView Scripting.
if you have sales data for different countries.
Now when you select India from country and in text object if you place GetPossibleCount(SalesData) it returns 2. B'coz we have 2 possible values for India. If you clear it will give 5
You can't use expression in getpossiblecount, we can use only fieldnames. Please try to convert all your expressions into script level. As below,
LOAD emp_name AS EmpID,
emp_name AS Name,
superior AS [Reporting To],
emp_sub_department AS Department,
(ooxml, embedded labels, table is Sheet1);
Hierarchy (EmpID,[Reporting To],Name,Manager,Name,EmpTree,'/',Level)
DROP TABLE Test;
if(Level=1,Name&chr(13)&emp_location&chr(13)&Department) as Level1,
if(Level=2,Name&chr(13)&emp_location&chr(13)&Department) as Level2,
if(Level=3,Name&chr(13)&emp_location&chr(13)&Department) as Level3,
if(Level=4,Name&chr(13)&emp_location&chr(13)&Department) as Level4
- Now add Level1 into listbox and in listbox properties -> Layout -> Show (enable conditional) and paste this exp =if(GetPossibleCount(Level1)>0,True(),False())
- Repeat this step for other listboxes by changing the expression. i.e. instead of Level1 use Level2, Level3 and Level4
Hope it helps you
Hey Tresesco Thanks a Ton.
This was something Awesome.............. Loved it..
Thanks You very Much. You made my day......... :-)