Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
nazaninslp
Contributor III
Contributor III

how show value in separated line in line chart

Dears

I have below container that include 3 line charts that they show revenue, subscription and charged MSISDNS pew Categories based on date_key.

4.PNG

the question is that I want show in first look the total revenues then when I click on my list box that shows categories (for example when I select 2 or 3 categories) my chart show them in different lines with different color.

but in my chart it show all of them in one line. (you an see in picture)

would you please help how can manage them?

dimension :  date_key

expression : sum({<Category-={"Test","Free ShortCode","Xtratime"}>}REVENUE)

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Add "Category" as a second dimension to your chart. For this dimension tick "Enable Condition" and use the conditional expression:

GetSelectedCount(Category)>0

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

View solution in original post

5 Replies
andrey_krylov
Specialist
Specialist

Try to add dimension with categories and set conditional show like

=If(GetSelectedCount(categories) > 0 and GetSelectedCount(categories) < 5, 1, 0)

balabhaskarqlik

Not sure, may be:

Modify the expression like this:

=If(GetSelectedCount(Category) > 0, sum({<Category-={"Test","Free ShortCode","Xtratime"}>}REVENUE))

Anil_Babu_Samineni

This is the case, You need 2 charts and overlapping into one and use Conditional Layout to achieve.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Add "Category" as a second dimension to your chart. For this dimension tick "Enable Condition" and use the conditional expression:

GetSelectedCount(Category)>0

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

nazaninslp
Contributor III
Contributor III
Author

it workkkkkkkkkkkkkkkkkkkkkkkkkkks fine, Thank youuuuuuuuuuuuuuuuuu Dear