topic Re: showing - symbol instead of amount in QlikView

showing - symbol instead of amount

Anonymous — Tue, 24 Jun 2014 06:17:48 GMT

Dear All,

i am showing closing stock and closing stock amount against Inventory posting group wise, for showing amount i am using amount flag selection for change values like thousands, millions and actual according the user selection.

i have an issue on that when i use amount flag to divide the expression for most of item no it showing value as '-' but when i select individual item it shows correct value overall it showing '-' but total is matching.

please understand the screen shot and help us to sort the issue.

=fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))/AmtFlag

when i remove amount flag it showing correct result.

=fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))

Thanks in advance

Siraj S

Re: showing - symbol instead of amount

phaneendra_kunc — Tue, 24 Jun 2014 06:24:15 GMT

Try sum(AmtFlag)

Re: showing - symbol instead of amount

jagan — Tue, 24 Jun 2014 06:28:17 GMT

Hi,

What are the values for AmtFlag? Are you selecting atleast one value? If you are selecting atleast one value then you will get the results.

Try

=fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))/Max(AmtFlag)

Regards,

Jagan.

Re: showing - symbol instead of amount

SunilChauhan — Tue, 24 Jun 2014 06:54:40 GMT

seems like only AmtFlag in denominator taking as 0 and thats why it shwoing - i.e undetermind value (when something/0)

try use below

fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))/

sum(AmtFlag)

hope this helps

Re: showing - symbol instead of amount

Anonymous — Tue, 24 Jun 2014 07:17:52 GMT

hi thanks for reply..

the values for amount flag is

AmtFlag, AMOUNTIN

1, ACTUAL

1000, THOUSANDS

1000000, MILLIONS

100000000, BILLIONS

here 1 actual flag is always one selected..

sum(AmtFlag) and Max(AmtFlag) both are not working..

Re: showing - symbol instead of amount

jagan — Tue, 24 Jun 2014 07:37:38 GMT

Hi,

Can you attach some sample file? It helps in identifying the issue.

Regards,

Jagan.

Re: showing - symbol instead of amount

Anonymous — Tue, 24 Jun 2014 09:05:52 GMT

Hi jagan...

the file size too huge so it is complicate to attach sorry......

Any solution for this........

Regards

Siraj S

Re: showing - symbol instead of amount

jagan — Tue, 24 Jun 2014 09:19:44 GMT

Hi,

Check this expression in text object and see whether you are getting the expected value?

sum(AmtFlag)

Only(AmtFlag)

Max(AmtFlag)

Regards,

Jagan.

Re: showing - symbol instead of amount

Anonymous — Tue, 24 Jun 2014 10:08:39 GMT

Thanks jagan i check and update you..

Re: showing - symbol instead of amount

Anonymous — Thu, 26 Jun 2014 12:16:06 GMT

Hi,

That

only(AmtFlag)

Max(AmtFlag)

sum(AmtFlag)

all these expression are not working please advice me....

Regards

Siraj

Re: showing - symbol instead of amount

CELAMBARASAN — Thu, 26 Jun 2014 13:13:42 GMT

Hi,

Post the screen shot by adding the AmtFlag field in the dimension.

And post a sample by reducing the data

100 Second Video - How to Reduce and Scramble a QVW