Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sanjujeeboy
New Contributor II

Calculated Dimension

i have created a calculated dimension;

if(abcd<>'Total',abcd)

In front end, if i select a particular value from this dimension abcd, it will show in current selections as

if(abcd<>'Total',abcd)

how to resolve this issue?

 

 

Labels (2)
2 Replies
Mauritz_SA
Contributor III

Re: Calculated Dimension

Hi there Sanju

Do you have access to the load script? Then you can use something like this:

LOAD

*,

if(abcd<>'Total',abcd) AS TestField

FROM ...

After this you can add TestField as a dimension and when you make a selection, it will show TestField (or whatever you call it) in the selection bar.

Not sure how you can do it in the front end though.

Hope this helps.

Mauritz

 

Highlighted
Employee
Employee

Re: Calculated Dimension

Hi Sanju,

You can create a dimension in the asset panel with that expression and use it in your chart. Check my example at 

https://community.qlik.com/t5/New-to-Qlik-Sense/Calculated-dimensions-in-selection-bar-Qlik-Sense/m-...

Regards,

Patrik.