Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner

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!”
kaveri_bhar123
Contributor II
Contributor II

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