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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Set Analysis, To Display All Years

Hi All,

My requirement is when user click year 2012 he want to see 2008 data(sales) in straight table for this i wrote exp:  Sum ({$<Year={$(=(Year)-4)}>}Sales)

this is working fine but user wants with out selecting year he wants to show all years data in Straight table

Please i need your assistance

Thanks in Advance

Nihhal

1 Solution

Accepted Solutions
Not applicable

Hi

try

if(getselectedcount(Year) <> 0 , Sum ({$<Year={$(=(Year)-4)}>}Sales), Sum(Sales))

View solution in original post

4 Replies
Not applicable

Hi

try

if(getselectedcount(Year) <> 0 , Sum ({$<Year={$(=(Year)-4)}>}Sales), Sum(Sales))

senpradip007
Specialist III
Specialist III

Could you upload a sample application ?

salto
Specialist II
Specialist II

Hi,

create a chart with Year as the dimension and  =Sum (Sales) as the expression.


Hope this helps.

nihhalmca
Specialist II
Specialist II
Author

Thank You Alexis Tan

NiHhal.