Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
yelin_nyu
New Contributor III

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).

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: toggle two things together

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

Gabriel

3 Replies
Employee
Employee

Re: toggle two things together

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

Gabriel

yelin_nyu
New Contributor III

Re: toggle two things together

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

Employee
Employee

Re: toggle two things together

Hi,

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

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

BR

Gabriel

Community Browser