topic Re: Variable does not work in QlikView

Variable does not work

Thu, 14 Jun 2012 12:33:57 GMT

Hello again,

i have two input fields, two variables: LastYear, CurrentYear

The input should connect to the command: Year

My expression looks like this:

sum({$<Year={"=$(LastYear)"}>}LINEAMOUNT)

What should this command do?

Summarize the Lineamount for the Year i wrote into the input field

But it doesnt give me what i want. It ignores it completely and gives me only Lineamount. Pls show me where i am wrong.

Thank you,

Kristian

Re: Variable does not work

Thu, 14 Jun 2012 12:48:20 GMT

sum({$<Year={'$(LastYear)'}>}LINEAMOUNT)

Re: Variable does not work

Miguel_Angel_Baeyens — Thu, 14 Jun 2012 12:48:33 GMT

Hi Kristian,

It depends on how you have set your variable. If you only input the numbers, for example 2011, then the following expression should work (note the lack of quoting and parentheses):

Sum({< Year = {$(LastYear)} >} LINEAMOUNT)

Hope that helps.

Miguel

Re: Variable does not work

Thu, 14 Jun 2012 13:28:16 GMT

Thank you very much. One more question if i may:

Attached is the table(picture) i am working on. In the filed "neto firme" i want to see the percentage share for the "Grupa" row of the TOTAL SUM(Grupa).

How can i address the total sum of grupa, what is the right formula for? I dont know the formula at all:

[LINEAMOUNT(selected year)]/ ...

Kristian

Re: Variable does not work

Miguel_Angel_Baeyens — Thu, 14 Jun 2012 13:29:48 GMT

Hi Kristian,

Not sure either but something like

Sum(Grupa) / Sum(TOTAL Grupa)

Hope that helps.

Miguel

Re: Variable does not work

Thu, 14 Jun 2012 13:37:53 GMT

Unfortunately not. When i try this formula:

[Promet Tek. godina]/sum(Total [Promet Tek. godina])

It doesnt show me anything...

Thank you for your time.

Kristian

Re: Variable does not work

Miguel_Angel_Baeyens — Thu, 14 Jun 2012 13:41:51 GMT

Kristian,

You will need to use the same expression under "Promet Tek. godina" (instead of the label) divided into the same expression, but using TOTAL as above.

Hope that helps.

Miguel

Re: Variable does not work

Fri, 15 Jun 2012 05:45:04 GMT

Thank you.

Kristian

Re: Variable does not work

Fri, 15 Jun 2012 06:32:06 GMT

These Variables are realy a pain in the sitting muscle...

Ive got a new one that doesnt work properly. I would appreciate any help

Formats:

Datum_fakture: dd.mm.yyyy

vDatum: dd.mm.yyyy

Count(DISTINCT {$<Datum_fakture = {"<=$(vDatum) >$(=AddMonths(vDatum,-12))"}>} CUSTACCOUNT)

This formula should:

Give me the count of Customers in the last 12 months fom the Date out of vDatum inputbox

Count(DISTINCT {$<Datum_fakture = {">=$(=AddMonths(vDatum,-12)) <$(=AddMonths(vDatum,-24))"}>} CUSTACCOUNT)

This formula should:

Give me the count of Customers in the previous12 months

No function works properly, can somebody show me where i am wrong?

Thank you

Kristian