how to set a default value in set expression and change on selection

[ashima_0605]

Hi All,

I have a scenario where I have created a table and a bar chart.

For the bar chart, I have show data using set expression for particular quarter. However when I change my quarter from the table, the bar chart doesnt change.

my expression in bar chart

Sum({<[Type] = {"Active"},Quarter = {'$(VCurrentQtr)'}, DataSource = {"AB"}>}(Value)/1000000)

But when I change the quarter in table, the bar chart doesnt change. How to ensure that by default graph will show one value and on selection in table, it should show others

[Anil_Babu_Samineni]

If you nothing select, show default with Max Quarter and filter as per user selection. Could be try this way?

If(GetSelectedCount(Quarter)>0, Sum({<[Type] = {"Active"},DataSource = {"AB"}>}(Value)/1000000), 

Sum({<[Type] = {"Active"},Quarter = {'$(VCurrentQtr)'}, DataSource = {"AB"}>}(Value)/1000000))

[ashima_0605]

Hi,

Thank you so much for replying quickly. The issue is that even with this code, it is not applying the filter of selected quarter.

So say,I was showing q3 by default, if I selected Q2, it should show q2 values. But it is not showing

[Qlik1_User1]

try this

If(GetSelectedCount(Quarter)>0, Sum({<({<Quarter= {'$(=Max({1}Quarter))'},[Type] = {"Active"},DataSource = {"AB"}>}(Value)/1000000), 

Sum({<[Type] = {"Active"},Quarter = {'$(VCurrentQtr)'}, DataSource = {"AB"}>}(Value)/1000000))

or create a bookmark on Quarter field and set that as default.