Straight Table Question

[#1]

Hi Guyz,

I am new to QlikView and completely stuck at a point.

I have a straight table and around 3 list boxes. Normally Table gets updated as soon as we select a item in list box, But my requirement is Table should not get updated till we select all the filters. It should be updated only after selecting all the filters and upon clicking on "Go" button. Till then straight table should not display any data.

How can I do this?

[Qrishna]

Alternate States is a different concept.

I guess its time consuming task  in your case/requirement.

Using variables is preferred as you have a  button which processes the selections into your chart.

[#3]

Thanks a lot Chaitanya.

One last question. Suppose I have more filters, Say 15..Then this concept of variables work?

Thanks a lot again,

Prasant

[Qrishna]

Absolutely.

But make sure you specify all those filters in the condition.

i.e if(GetSelectedCount(Year)>=1 and GetSelectedCount(Quarter)>=1 and GetSelectedCount(Month)>=1,

GetSelectedCount(filter4)>=1 and GetSelectedCount(filter5)>=1 .... and GetSelectedCount(filter15)>=1,'Go',0)

[sriram____777]

How to acheive the same in qliksense

[Amit_Prajapati]

Hi @sriram____777 , We can integrate the calculation shared by @Qrishna  into the Add-ons section.

To enhance clarity, let's include a message above the chart prompting users to apply the necessary filters—such as Year, Month, or Quarter—as required by the report. This will help ensure the chart displays accurate and meaningful insights.