topic Re: Qlikview doubt (Straight table features) in QlikView

Qlikview doubt (Straight table features)

vijay4b4 — Fri, 02 Sep 2022 13:54:31 GMT

Hi,

I created a straight table with 1 dimension and a measure. when i select a specific value in that particular dimension list box, that measure's exact value is shown. but when i dont make a selection, measure values are showing zeroes.

*Only for that particular measure. other different measures are working fine.

Can i get a help here please?

Re: Qlikview doubt (Straight table features)

Aurelien_Martinez — Fri, 02 Sep 2022 13:54:20 GMT

Hi,

Can you share your expression ?

Aurélien

Re: Qlikview doubt (Straight table features)

vijay4b4 — Fri, 02 Sep 2022 13:59:31 GMT

num(sum({<POSITION_DATE={"06/02/2022"}, QUOTE_CCY_CD={"$(vCurrencyReport)"}>} ACCOUNT_CUR_SETTLED_AM*FX_RT)/1000000,'##,##0.0')

//vCurrencyReport is just a currency code

Re: Qlikview doubt (Straight table features)

Aurelien_Martinez — Fri, 02 Sep 2022 14:24:32 GMT

If you write the same expression without FX_RT, do you have a result ?

num(sum({<POSITION_DATE={"06/02/2022"}, QUOTE_CCY_CD={"$(vCurrencyReport)"}>} ACCOUNT_CUR_SETTLED_AM)/1000000,'##,##0.0')

Re: Qlikview doubt (Straight table features)

vijay4b4 — Fri, 02 Sep 2022 14:41:40 GMT

No change. zeroes are shown.

Re: Qlikview doubt (Straight table features)

BrunPierre — Sat, 03 Sep 2022 12:55:37 GMT

Try with the expression without the sets, and work your way up from there.

Alternatively, try with this

IF(count(GetCurrentSelections()>0), ExpressionWhenSelectionIsMade, ExpressionWhenSelectionIsMade)

Re: Qlikview doubt (Straight table features)

oskartoivonen — Mon, 05 Sep 2022 07:08:33 GMT

As general advice, if a measure is behaving in a irregular way, the best way to debug is to first find a concise and clear example for which you can easily determine what the correct value from the measure should be, such as selecting a specific order or account or product combined with a month, whatever is most clear. Then, strip the measure of any extras, set analysis/ifs/formatting and just pure Sum(Field). Assuming that simple measure is working correctly, i.e. there's no issue in the actual fact data in the data model, you can start adding stuff back in like the set analysis one step at the time, and see at what point you start getting issues. That should help you locate your problem and give clarity how to solve it.