Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Noor51
Creator
Creator

How to create a formal that shows data from what you select on the graph?

I trying to create a table when a user select a month on a graph it shows the select month, pervious month, and the variance between them. The expression I use doesn't pick up the month, and I don't understand why. Can someone explain it to me.  (CM mean Current Month)

Noor51_1-1683816730929.png

 

Noor51_0-1683816674026.png

Noor51_2-1683816750144.png

 

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this 

Selected month 

Sum({<Month={'$(=Only(Month))'}>} Amount)

 

Previous month 

Sum({<Month={'$(=AddMonths(Only(Month), -1))'}>} Amount)

 

For variance

Sum({<Month={'$(=Only(Month))'}>} Amount) - Sum({<Month={'$(=AddMonths(Only(Month), -1))'}>} Amount)

 

Please modify your fieldnames accordingly in above expression i have given sample example 

 

View solution in original post

1 Reply
Chanty4u
MVP
MVP

Try this 

Selected month 

Sum({<Month={'$(=Only(Month))'}>} Amount)

 

Previous month 

Sum({<Month={'$(=AddMonths(Only(Month), -1))'}>} Amount)

 

For variance

Sum({<Month={'$(=Only(Month))'}>} Amount) - Sum({<Month={'$(=AddMonths(Only(Month), -1))'}>} Amount)

 

Please modify your fieldnames accordingly in above expression i have given sample example