Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
yelin_nyu
Creator
Creator

toggle two things together

Hi 3 things i want to achieve here (don't know if it's possible or not)

in the test file, there 2 versions, unit and $.

1. When users toggle through columns in straight table, I want them to view everything in $ or units. how to make the toggle to move together?

2. The line graph shows a aggregated sum of 2 products, how do i make them shown as seperate lines? (in my original database, I got about 10,000 products, so i prefer to only show aggregated sum if no product is selected, but if users select a limited number of products, say, 5, show as seperate lines)

3. since there are toggles on both line graph and table, can they move together? say if i toggle to display in units, both graph and table are show in units, vice versa.

Big thanks. Please let me know which part you worked on. 1 is most important. (3 is somewhat related).

1 Solution

Accepted Solutions
GabrielAraya
Employee
Employee

Hi .. I don't know if I answerd your doubts .. please see the qvw attached ,,

Gabriel

View solution in original post

3 Replies
GabrielAraya
Employee
Employee

Hi .. I don't know if I answerd your doubts .. please see the qvw attached ,,

Gabriel

yelin_nyu
Creator
Creator
Author

can i format these 2 measures? units as it is, but $ make it round to $ and add $ sign?

GabrielAraya
Employee
Employee

Hi,

Sure, you can do that in the same expression .. like this:

If ( vType = '$',Num(sum(price*ordered),'$ #,###'),sum(ordered))

BR

Gabriel