topic Re: Calculated Dimension with if Condition Qliksense in App Development

Calculated Dimension with if Condition Qliksense

bhargav_bhat — Fri, 08 Dec 2017 02:53:53 GMT

Hi all,

We are having a requirement where we have a filter with two options Yearly and Monthly level in Qliksense.

Based on the selection, the Dimension in the charts should change to Year or Month.

We are using following expression for the Dimension

if(getfieldselections(Period) ='Yearly',[Year],[Month])

It works fine if you select Yearly or Monthly in Period filter but as soon as we filter using Dimension Year or Month

it behaves in a strange manner.It shows Dimension only at Monthly Level even if you have selected Yearly or Monthly in Period filter

So it ignores the if condition and selects the else condition as shown below

if(getfieldselections(Period) ='Yearly',[Year],[Month])

We tried using Master items as dimension but it was giving same results

Needed help on this

Regards,

Bhargav

Re: Calculated Dimension with if Condition Qliksense

luismadriz — Fri, 08 Dec 2017 03:45:24 GMT

Hi,

Create a little text box and display the results of getfieldselections(Period) and see if it changes as you make other selections

Cheers,

Luis

Re: Calculated Dimension with if Condition Qliksense

luismadriz — Fri, 08 Dec 2017 04:20:47 GMT

No that's not it.

Is Period in any way linked to other fields in your database? I hope not, it should be an island table (not connected to anything) and not existing in a table with other fields

Luis

Re: Calculated Dimension with if Condition Qliksense

bhargav_bhat — Fri, 08 Dec 2017 06:13:00 GMT

Hi Luis,

Thanks for Replying,

Period Field is not linked to any field and I have taken an inline load for it.But strange thing is when we filter a dimension Year or Month then both values in Period field i.e Quarterly and Monthly gets selected automatically even without association

I have attached a qvf file for reference

Thanks & Regards,

Bhargav

Re: Calculated Dimension with if Condition Qliksense

calexandru — Fri, 08 Dec 2017 06:53:45 GMT

Hi Bhargav,

Might I suggest you try out the qsVariable extension over on Qlik Branch? It looks like it might be exactly what you are looking for.

You can create two buttons, Yearly and Monthly and based on the user's selection have the measure return different calculations by way of an if statement. As an approach it's very similar to your implementation but it should be more fluid in terms of user interaction.

Cheers,

Alex