
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculation Condition
hi,
i'm working in a dynamic table, but i have 1 dimensions and 2 expression in-lines
the dynamic table depends of the 3 in-lines.
obviously the principal its the dimension inline and i have in order to organize the units separately of money expressions in 2 different in-lines.
if the user only wants to watch units information he selects those expressions.
if the user only wants to watch money information he selects those expressions.
if the user wants to watch unit and money information he select the expressions he wants.
the problem that i have its that i don't know how to control the visualization of 2 expression in-lines because
if the user selects for example units expressions the table shouldn't show the money expressions.
if the user selects for example money expressions the table shouldn't show the units expressions.
right now if i select only units expressions the money expressions are showing or backwards.
the calculation condition that i have in the moment its:
Count(GetFieldSelections(Dimensions)>1) and (Count(GetFieldSelections(Units)>1) or Count(GetFieldSelections(Money)>1))
how i can do this?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
tnks Anand you give a great idea
in the calculation condition i put that so its
Count(GetFieldSelections(Dimensions)>1) and
( GetSelectedCount(money)>=1 or GetSelectedCount(units)>=1 )
but in the conditional of each expression the same
if(GetSelectedCount(money)>=1,SubStringCount(Concat(money,'|'),'xxxx'),0)
if(GetSelectedCount(units)>=1,SubStringCount(Concat(units,'|'),'yyyy'),0)
tnks!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Try:
Getselectedcount(Dimensions)>1
BR
Serhan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can use the Adhoc reports functions also for this.
http://community.qlik.com/docs/DOC-5404
Regards,
Anand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
Manish i'm using that post by if you can see it only have q one dimension and one expression it doesn't solve my problem

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi Anand,
its the same of Manish
i'm having 2 measures or expression tables with one dimension table, how i can control 3 tables in the calculation condition??

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Then implement with Getselectedcount() woth dimension selection count, IN the chart layout properties enable or disable the chart with condition
Getselectedcount(FieldName) = 1
Or
Getselectedcount(FieldName) > 1
Regards
Anand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
tnks Anand you give a great idea
in the calculation condition i put that so its
Count(GetFieldSelections(Dimensions)>1) and
( GetSelectedCount(money)>=1 or GetSelectedCount(units)>=1 )
but in the conditional of each expression the same
if(GetSelectedCount(money)>=1,SubStringCount(Concat(money,'|'),'xxxx'),0)
if(GetSelectedCount(units)>=1,SubStringCount(Concat(units,'|'),'yyyy'),0)
tnks!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks it worked for you
Regards
Anand
