Conditional filter in Qliksense

[kumarkp412]

Dear All,

I want to create a filter called branch and it should show the names as per the current year how many branches are there .

When i try to create a condition filter, it was throw me an error and it says as invalid dimension.

for I uses as

only({<year='2017'>}branch).

I was strucks here .Can you one help on this , it would be appreciated.

Thanks in advance

Thanks

Kumar KVP

[sunny_talwar · Accepted solution]

May be try this

If(year = 2017, branch)

or this

Aggr(Only({1<year = {2017}>} branch), branch)

[shraddha_g]

Try

Only({<year = {'2017'}>}branch)

[Mark_Little]

HI

I think the first suggestion by Sunny has suggested is what your looking for.

IF(year=2017, branch)

Only() function is used when your set analysis will only ever return a single value, the error is occurring as you will have multiple branches in your data with the year of 2017, so it doesn't know which one to return.

Mark

[Chanty4u]

try like this

aggr(Only({<year = {'2017'}>}branch),branch)

[kumarkp412]

Hi Sunny,

Thanks for your reply.

I tried with the if condition what you mentioned. It was selecting entire data as 2017. I didnt need this.

I want only this branch filter should show the current year possible value of branches in it.

Also when i try with having the only function it was throw as invalid error.

Thanks in advance

Thanks

Kumar KVP

[shraddha_g]

Share sample app

Solutions provided by Sunny should work..

[martinpohl]

you need to calculate the condition for each value, so aggr is needed.

use

=aggr(only({1<year={'2017'}>}branch),branch)

Regards

[kumarkp412]

Thanks Sunny,

It was working fine when i uses the second expression.

Thanks

Kumar KVP