topic Re: Straight Table Question in QlikView

Straight Table Question

Wed, 26 Aug 2015 10:30:51 GMT

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?

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 14:52:44 GMT

Hi prashant,

For sure we can achieve this by using variables and applying some conditions in the table chart.

Post your demo application.

Re: Straight Table Question

Wed, 26 Aug 2015 15:08:04 GMT

Hi Chaitanya,

Please find the attachment for the data sheet and the QVW file. I have some list boxes and a Straight table in the file.

Let me know if anything else needed.

Thanks for your help,

Prasant Tata

Re: Straight Table Question

Wed, 26 Aug 2015 15:10:16 GMT

Also I am trying to do this with the concept of "Alternate States" which I found in another community. For some reason it didn't work out for this app. Can you please also throw some light on this?

Thanks,

Prasant Tata

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 15:12:06 GMT

you have 5 list boxes.

what are the 3 list boxes which are acting as filters?

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 15:12:44 GMT

Let me know the filters?

Re: Straight Table Question

Wed, 26 Aug 2015 15:16:14 GMT

Month, Year and Division

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 15:44:26 GMT

See attached.

let me know if thats what you wanted?>

Re: Straight Table Question

Wed, 26 Aug 2015 15:58:26 GMT

Hey,

That completely works for the requirement... Can you please explain me where I went wrong. I have created Alternate States but that didn't work, DO I need to perform something other than creating those states. Please Let me know.

Thanks for your help,

Prasant Tata

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 16:13:24 GMT

You have set a variable which only has value when all the filters have been selected.

Thats what

=if(GetSelectedCount(Year)>=1 and GetSelectedCount(Quarter)>=1 and GetSelectedCount(Month)>=1,'Go',0)

means.

on the chart, you have to specify calculation condition.

i.e on general tabl of chart vGo = 'Go' means

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 16:17:13 GMT

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.

Re: Straight Table Question

Wed, 26 Aug 2015 16:29:17 GMT

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

Re: Straight Table Question

Qrishna — Wed, 26 Aug 2015 16:31:22 GMT

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)

Re: Straight Table Question

sriram____777 — Tue, 23 Jul 2024 02:32:42 GMT

How to acheive the same in qliksense

Re: Straight Table Question

Amit_Prajapati — Thu, 09 Oct 2025 08:53:13 GMT

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.