topic Re: How can I Hide expression in Pivot Table QV11 in QlikView

How can I Hide expression in Pivot Table QV11

Fri, 22 Aug 2014 06:59:20 GMT

HI,

I am using QV11, Quick glance about variables (Expressions) I have in Pivot Table:

1. Total Orders : [ Expression - (count(distinct(order_number))]

2. Promotional Orders : [ Expression - (count(distinct(if(promo_order_flag=1, order_number)))]

3. Promotional Orders % : Expression - Calculated field from above 2: [1] / [2] = [Promotional Orders] / [Total Orders]

I want to display Promotional Orders and Promotional Orders % in a Pivot Table.

Can you please help in Hiding 1. Total Orders But use it in calculation to create 3. Promotional Orders %

Many Thanks and Regards

- Deep

Re: How can I Hide expression in Pivot Table QV11

Sokkorn — Fri, 22 Aug 2014 07:03:10 GMT

Hi Deep,

You may try this. Go to Expression -> check on Conditional with expression 1<>1

Rgds,

Sokkorn

Re: How can I Hide expression in Pivot Table QV11

Fri, 22 Aug 2014 07:19:42 GMT

Hi Sokkorn,

Thank You for suggestion, but unfortunately it is not working for me.

It Hide Total orders successfully but also I loose 3. Promotional Orders % (where I was using total orders).

Please find screenshot below with Before(Green) and After (Red)

many Thanks

- Deep

Re: How can I Hide expression in Pivot Table QV11

Sokkorn — Fri, 22 Aug 2014 07:25:52 GMT

Hi Deep,

Is it possible to share your app?

Rgds,

Sokkorn

Re: Re: How can I Hide expression in Pivot Table QV11

Fri, 22 Aug 2014 07:42:02 GMT

Please find the attached file

Re: Re: Re: How can I Hide expression in Pivot Table QV11

Sokkorn — Fri, 22 Aug 2014 08:08:08 GMT

Hi Deep,

If the [Total Order] not require to show in chart, then why don't we use [Promotional Orders]/count( {$<promo_order_flag =, year_no=, day_no=, month_no=, redemption_type=>}distinct order_number)

Or keep [Total Order], but use macro

Re: How can I Hide expression in Pivot Table QV11

hannan_t — Fri, 22 Aug 2014 08:22:52 GMT

Try this and hopefully you'll get your results.

1. Promotional Orders : [ Expression - (count(distinct(if(promo_order_flag=1, order_number)))]

2. Promotional Orders % : Expression - Calculated field from above 2: [1] / [(count(distinct(order_number))] = [Promotional Orders] / [Total Orders]

Re: Re: How can I Hide expression in Pivot Table QV11

Mon, 25 Aug 2014 09:45:24 GMT

Thank You Guys,

I used part of both solutions and it is working now

Thank You for your help!

Regards

- deep