topic Re: Re: Static variable in Water Cooler

Static variable

Thu, 13 Feb 2014 08:53:41 GMT

Hi Guys,

How can I make static condition if with static variable that will not be effect while making selection.

Regards,

Ayham

Re: Static variable

sundarakumar — Thu, 13 Feb 2014 09:00:14 GMT

You can go for set analysis if u deont want your selections to get reflected in the chart.

You can create a Static variable in Variable Overview.

Just use "=" while creating the variable in variable overview tab this will make it static.

Please specify condition or what variable u want to create , so that we can help.

-Sundar

Re: Static variable

Peter_Cammaert — Thu, 13 Feb 2014 09:00:25 GMT

Set analysis? TOTAL prefix?

Do you have a case that we can help you with?

Peter

Re: Static variable

martinpohl — Thu, 13 Feb 2014 09:06:42 GMT

for example

sum({<Year=>}Amount)

this will sum the amount matching to all selections without the selections in the field Year

Regards

Re: Re: Static variable

Thu, 13 Feb 2014 10:33:10 GMT

Thanks for your replay and kindly find the attached copy of excel sheet document,

I have excel sheet, the first tab contains the data and the second tab contains report.

I want to view the report in the same layout on the top of Qlikview.

This report has table with milt-headers.

When you open the excel sheet, you will get my Idea because I need to build conditions on constant variables to calculate report excel sheet equations.

Could you kindly please suggest for me way of how can I build this report on the same layout with same result without making any selection to get the same result of report on the top of Qlikview?

Best Regards,

Ayham

Re: Re: Re: Static variable

Peter_Cammaert — Thu, 13 Feb 2014 11:33:53 GMT

Something like this?

Note that QlikView is not Excel. There are things in QlikView that you cannot reproduce in Excel and vice-versa. For example all Subtotals can be put either at the top or the bottom of a range of cells. But you cannot change the positions depending on the dimension level.

Good luck,

Peter

Re: Re: Re: Static variable

Thu, 13 Feb 2014 11:49:31 GMT

Mr.Peter,

Is there any way to build pivot table close to report excel sheet table.

if there is, could you please upload an Qlikview document example ?

Thanks for your reply,

Ayham

Re: Static variable

Peter_Cammaert — Thu, 13 Feb 2014 12:12:59 GMT

AFAIK No, not without a lot of work.

Again, QlikView is not Excel.

You can try yourself to tweak colors, font sizes and positions so that it better suits your user.

Good luck,

Peter