Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

yelin_nyu
Contributor

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
Contributor

Re: toggle two things together

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

Highlighted
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