topic Re: Text box to show conditional text based on selected dimesion in QlikView

Text box to show conditional text based on selected dimesion

Sun, 26 Jun 2016 04:39:11 GMT

Hi All,

I need an expression to put in a text box or create a variable using that expression to display text based on selected dimension

Data Model

I have a Department Table
And a Team Table (Which links to department with DepartmentId as foreign key)
NOTE: Some Departments does not have teams

An an Example:

Sales Department has 3 Teams (Team1, Team2, Team3 )
And Finance Department has NO Teams

If Department is selected as 'Sales'
Then it should say 'Click here to drill down to team'

If Department is selected as 'Finance'
Then it should say 'No Teams for this department'
Because this department does not have any teams

Re: Text box to show conditional text based on selected dimesion

marcus_sommer — Sun, 26 Jun 2016 05:25:09 GMT

Maybe something like this:

if(count(distinct Department) >= 0, 'Click here to drill down to team', 'No Teams for this department')

- Marcus

Re: Text box to show conditional text based on selected dimesion

maxgro — Sun, 26 Jun 2016 05:48:42 GMT

try the attachment

= IF(GetPossibleCount(Team)>0 and GetSelectedCount(Department)=1, 'Click here to drill down to team', 'No Teams for this department / Select 1 department')