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: 
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