topic Re: What is column purpose in QlikView

What is column purpose

krishnakv83 — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

if ( (column(1)-sum(PLANNED_SALES_RETAIL)) < 0 , (column(1)-sum(PLANNED_SALES_RETAIL)) *-1,(column(1)-sum({<FLAG_YTD={'Y'}>}PLANNED_SALES_RETAIL)))

In the above formula what is purpose of column(1) ?Pls help me understand

Regards,

Venkat

Re: What is column purpose

jonathandienst — Tue, 05 Apr 2016 16:02:08 GMT

Column(1) refers to the result of the first expression in the table or chart.

Re: What is column purpose

Chanty4u — Tue, 05 Apr 2016 16:03:36 GMT

what ever the expression which u hve used in ur First expression ur chart or table.

if that expression is complex...at that time we can use column names.

hope this helps u

Re: What is column purpose

engishfaque — Tue, 05 Apr 2016 19:21:43 GMT

Dear Krishna,

Column and Expression both are same in charts. For example you have a chart where there are two expression for Sales and Expenses. But you want to calculate profit in third expression. So you didn't need to write whole expression for Sales and Expenses. You can just write that Profit = Column(1) - Column2.

Example 1:

Column(1) means Expression1

Column(2) means Expression2

Example 2:

Expression1/Expression2 both are labels then you can also write Expression1/Expression2 instead of complete expression or Column(1) or Column(2).

Listed below expressions will return you same result

Profit = Sum(Sales) - Sum(Expenses)

Profit = Column(1) - Column(2)

Profit = Expression1 - Expression2

Please note, Profit formula can be change according to your requirements. Given above Profit formula is only for quick understanding.

Kind regards,

Ishfaque Ahmed

Re: What is column purpose

krishnakv83 — Thu, 07 Apr 2016 06:01:01 GMT

Thank you all for the reply.Now I understood advantages of column(1) .It is very useful for lengthy expressions.

Re: What is column purpose

Chanty4u — Thu, 07 Apr 2016 06:53:06 GMT

yes exctly....

if u got the solution please close this thread by making helpful and correct answer above. if not please raise ur quires

Qlik Community Tip: Marking Replies as Correct or Helpful