topic Exclude Yearselection in QlikView

Exclude Yearselection

Mon, 11 Jun 2012 05:23:29 GMT

Hi,

if(TRIM(Group1)='Cash Flow From Operating Activities:-' or TRIM(Group1)='Change in C/A' or TRIM(Group1)='Change in C/L' or TRIM(Group1)='Cash Flow From Investing Activities:-' or

TRIM(Group1)='Cash Flow From Financing Activities:-' or TRIM(Group1)='Summary of closing cash',' ')

Above is my expression where if these group1 values are in the dimension then instead of amount it will show space since they r headers/titles,

Problem is when i filter using year ,all these group1 values does not show in straight table since there r no dates for these group1 values,

how to exclude year selection for all these Group1 values?

Exclude Yearselection

jagan — Mon, 11 Jun 2012 06:17:42 GMT

Hi,

Use

YearField=

in expression.

Ex: Sum({<YearField=>} Sales)

The above expression excludes YearField selection.

Hope this helps you.

Regards,

Jagan.

Exclude Yearselection

Mon, 11 Jun 2012 06:22:12 GMT

Hi Jagan,

I cannot apply sum since i want space instead of amount for the above group1 values,sum of space will not be shown in straight table.