topic Re: need suggestion in QlikView

need suggestion

Thu, 27 Mar 2014 09:49:44 GMT

In my application I want to show the current quarter data.It means if a quarter starts from 21st march 2014 to 21st june 2014 than my application shows data only according to that current quarter and nd application will automatically update according to the current quarter.attached a sample excel which is showing how data is given in excel sheet.

need help to write script

Re: need suggestion

jsingh71 — Thu, 27 Mar 2014 10:11:38 GMT

Can you explain little bit more about your requirement.

--Jai

Re: need suggestion

vikasmahajan — Thu, 27 Mar 2014 10:45:05 GMT

you need to apply like wise comparison please study attached qvw will help you.

Vikas

Re: need suggestion

PradeepReddy — Thu, 27 Mar 2014 11:03:13 GMT

We can achieve this in below manner...

1. First select Quarter_Name for the current date and assign it to the variable.

2. Then read th data from excel, having current Quarter_Name. (Variable)

Regards,

Pradeep

Re: need suggestion

Thu, 27 Mar 2014 11:04:40 GMT

@vikasMahajan I am Unable to find attach QVW file

Re: Re: need suggestion

vikasmahajan — Thu, 27 Mar 2014 11:13:03 GMT

pfa

Re: need suggestion

Thu, 27 Mar 2014 11:13:52 GMT

@Jai what i want is that to show data according to current quarter in my application.

i have given an example like i specify Quarter as(Start date 21 jan2014,End date 21 mar 2014),

So I want to show that which falls in that date only.i dnt want to show historical data.i want to show only current data.

i attached a sample which shows how my data looks like in an excel.

if you need more explanation please let me know i will tell you my requirement.

Re: need suggestion

PradeepReddy — Thu, 27 Mar 2014 13:52:25 GMT

paridhi agrawal

We can achieve this in design side also.. we can opt the option "on opening document"

below is the steps to be followed

1. Load the table.

2. Seettings--> Document Properties(CTRL+ALT+D) --> Triggers --> Document Even Triggers--> Add actions

we have to add 2 actions here, one for Year and other for Quarter

1) onOpen--> Add--> Select in Field

Field name : Year

Search String : Year(today())

2) onOpen--> Add--> Select in Field

Field Name : Quarter (in your example this is .. Q)

Search String : 'Q' &Ceil(month(today())/3)

How this works is... on opening the document it will check the today's year and quarter and accordingly it selects the data..

Thanks,

Pradeep

Re: need suggestion

PradeepReddy — Thu, 27 Mar 2014 18:07:10 GMT

paridhi agrawal

If this solution works for you, mark it is Correct Answer.. So that it if any others faces same issue can look into this.

Regards,

Pradeep

Re: need suggestion

Fri, 28 Mar 2014 05:53:53 GMT

I will surely mark it if it works.

Re: need suggestion

Fri, 28 Mar 2014 06:36:38 GMT

@pradeep taniparthy.i tried this,its dshowing the current year and current quarter dat but data is not freezes.we can change it.

i want that data to be frrezed when we open the document.

Re: need suggestion

PradeepReddy — Fri, 28 Mar 2014 06:53:39 GMT

paridhi agrawal

Try the below settings along with the above options..

Add one more action on document opening.

Doc Properties--> Doc even Triggers--> On openingDoc--> Add--> Selection --> Lock Field --> Quarter (Field Name)

Re: need suggestion

Fri, 28 Mar 2014 07:49:18 GMT

@pradeep taniparthy if we do this than it locks that particular field.but if the data is again refresh than how it will change the data in application.

Re: need suggestion

PradeepReddy — Fri, 28 Mar 2014 08:02:10 GMT

We are locking the field only not the value. Whatever the current quarter, we are locking that only...

If you want to test the scenario, take the data for next quarter... and change the expression in quarter selection to ='Q'&Ceil((month(today())+2)/3).

After reloding the data... save the document, Close the document and open it again... it will work.