Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help with an expression - might be a simple solution I think but need guidance

Hi,

I have created a table that has 'Name' as the dimension and the following expression:

if(Count(${<Skill={'Pro','Amateur'}, Role={'Senior'}, Active={'Y'}, NoOfDaysPassed={">30"}>} ID)>=1,1,0)

The above criteria returns a 1 for names in the dimension.

I wanted to know how to get the sum/total for this and be able to put it into a Text Object.

Any ideas on what the best way to do this is?

1 Reply
tamilarasu
Not applicable

Re: Help with an expression - might be a simple solution I think but need guidance

Hi Mavrinder,

Simply, put this in text box.

Count(${<Skill={'Pro','Amateur'}, Role={'Senior'}, Active={'Y'}, NoOfDaysPassed={">30"}>} ID)

Even if it is zero, the sum will be same.