topic Range Sum Restriction in QlikView

Range Sum Restriction

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I wanted to hide,restrict the Range Sum value for Q1. How to achieve this?

Thanks in advance.

Please check the sample file.

Re: Range Sum Restriction

shanemichelon — Thu, 11 Jun 2015 04:23:20 GMT

Re: Range Sum Restriction

help4qv123 — Thu, 11 Jun 2015 04:53:52 GMT

If your issue is solved just mark it correct , so that people will know. Dont Just use community for your sake. Just for your solutions, 1ce they are solved you are least bothered about the person who helped. Try to mark the status ,......

Re: Range Sum Restriction

jagan — Thu, 11 Jun 2015 05:10:55 GMT

Hi,

I think it is not possible, on what basis you want hide Q1, suppose if we are in Q3 then what is the case?

Regards,

Jagan.

Re: Range Sum Restriction

shanemichelon — Thu, 11 Jun 2015 05:14:34 GMT

I Don't think he wants to hide Q1. He stated that he wants to hide the rangeSum value. If it is only the rangesum vaue for only Q1, then you cannot do it without resorting to a Macro.

Re: Range Sum Restriction

jagan — Thu, 11 Jun 2015 05:17:38 GMT

Sorry for the confusion, my question is

I think it is not possible, on what basis you want hide Rangesum for Q1, suppose if we are in Q3 then what is the case?

Re: Range Sum Restriction

qlikviewwizard — Thu, 11 Jun 2015 05:30:24 GMT

Hi jagan and ShaneMichelon,

I want to hide only for Q1. Pls check the pic and app. !

Re: Range Sum Restriction

qlikviewwizard — Thu, 11 Jun 2015 05:35:00 GMT

Can you tell me,Where did you find that I was not closed the thread?

Re: Range Sum Restriction

qlikviewwizard — Thu, 11 Jun 2015 05:36:06 GMT

Hi ShaneMichelon,

Please provide the macro solution.

Thanks in advance.

Re: Range Sum Restriction

jagan — Thu, 11 Jun 2015 05:42:28 GMT

Hi,

Can you attach the excel use you used in the Qlikview file?

Regards,

Jagan.

Re: Range Sum Restriction

qlikviewwizard — Thu, 11 Jun 2015 05:47:34 GMT

Hi jagan,

Please find the attachment.