topic Re: Creating Field in QlikView

Creating Field

Tue, 16 Jun 2015 20:45:09 GMT

Hello -

My data set contains an amount field, with both positive and negative amounts. I would like to be able to filter my dashboard on all positive amounts and I don't want to have to click on all the positive amounts in the listbox. I was thinking the easiest way would be to create a Positive/Negative indicator field that would mark all positive amounts as "Positive" and all negative amounts as "Negative". How would I go about doing that? Is there a better way to filter on all positive or all negative values?

Re: Creating Field

sinanozdemir — Tue, 16 Jun 2015 20:50:35 GMT

In the list box, you can create an expression:

If the dimension is greater than 0, then dimension. In this way, you are only pulling the positive numbers.

Hope this helps

Re: Creating Field

Anonymous — Tue, 16 Jun 2015 20:53:10 GMT

use a listbox where you can select your positive values with ">0"

what you mentioned by a indicator field would be created in script by

if value>0,'pos','neg') as Indicator

Re: Creating Field

MarcoWedel — Tue, 16 Jun 2015 20:53:55 GMT

create buttons with search in field actions.

hope this helps

regards

Marco

Re: Creating Field

Clever_Anjos — Tue, 16 Jun 2015 21:18:22 GMT

Just type ">0" into your listbox

Re: Creating Field

MarcoWedel — Tue, 16 Jun 2015 21:58:07 GMT

Hi,

one example for selection buttons and an additional field created in the load script:

tabAmounts:
LOAD *,
    Pick(Sign(amount)+2,'negative','zero','positive') as [amount sign];
LOAD RecNo() as ID,
      Round(Rand()*40-20) as amount
AutoGenerate 30;

hope this helps

regards

Marco