Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vijay4b4
Contributor III
Contributor III

Qlikview doubt (Straight table features)

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?

QlikView 

Labels (1)
6 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

Can you share your expression ?

 

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
vijay4b4
Contributor III
Contributor III
Author


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

 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

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') 

Help users find answers! Don't forget to mark a solution that worked for you!
vijay4b4
Contributor III
Contributor III
Author

No change. zeroes are shown.

BrunPierre
Master
Master

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

Alternatively, try with this

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

oskartoivonen
Partner - Contributor III
Partner - Contributor III

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.