topic Re: toggle two things together in QlikView

toggle two things together

yelin_nyu — Thu, 04 Oct 2012 21:09:49 GMT

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

Re: toggle two things together

GabrielAraya — Thu, 04 Oct 2012 21:26:20 GMT

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

Gabriel

Re: toggle two things together

yelin_nyu — Thu, 04 Oct 2012 22:27:26 GMT

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

Re: toggle two things together

GabrielAraya — Fri, 05 Oct 2012 17:57:13 GMT

Hi,

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

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

Gabriel