Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting specific members of a dimension

Hello,

One of my dimensions is the Account, that has values ranging from 10000 to 99999.

What and where do I need to write in order for the report to show me data for accounts 40000 to 69999 only?

Thanks

Laila

9 Replies
adamdavi3s
Master
Master

sum({<Account= {">=40000 "}, Account= {"<=69999 "}>}Data)



Will do the trick, assuming your accounts are numeric

ali_hijazi
Partner - Master II
Partner - Master II

in set analysis

sum({<Account={">=40000 <=69999"}>}amount)

I can walk on water when it freezes
HirisH_V7
Master
Master

Hi,

Check this, as your expression

Sum( {<Account={'>=40000 <=69999'} >} YourExpressionField)

or

Dimension like this,

=If(Account>='40000' and Account<='69999',Account)

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Not applicable
Author

Hello Hirish,

Thanks for your reply.

How can I see each account in the range separately and not summed?

When I used your 'if' suggestion, it didn't work.

By the way, the dimension is called 'G_L Account No_' - do I need to enter this full name into the If statement? Should I add an apostrophe? This: If('G_L Account No_'>='40000' and 'G_L Account No_'<='69999','G_L Account No_') didn't work..

Thanks

Laila

HirisH_V7
Master
Master

Hi,

Check like this, as your dimension,

If([G_L Account No_]>='40000' and [G_L Account No_]<='69999',[G_L Account No_])




-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Anonymous
Not applicable
Author

Hi Laila,

You could the filter data using "dimension limit" options where you could set your desired expressions.

Best regards,

Kaveri

qlik_jaijhn
Contributor II
Contributor II

sum({<Account={">=40000 <=69999"}>}amount)

nitin_01
Creator
Creator

Hi Laila,

For Calculated Dimension :

                                            If([G_L Account No]>='40000' and [G_L Account No]<='69999',[G_L Account No])

Expression or Measure :

                                       Sum({$<[G_L Account No]={">=40000<=69999"}>} [Measure])

Regards

Not applicable
Author

Hi,

Did you mean entering it in the Dimension, as in the photo attached?

If so, then it's not working, as I get a total column (see beind window in the photo).

I would like to see each account within the range, separately.

Thanks

LailaAccount dimension.jpg