topic Re: Is it possible to design? in QlikView

Is it possible to design?

Sun, 03 May 2015 03:40:28 GMT

Hi All,

I am develop one straight table. In that table i am using dimension as Expenses and expressions as previous month and current month. It display proper way corresponding current month and previous month. But i am taken month as dimension and expressions as previous month and current month.it not display proper way.

Any one please help me in this part and solve the problem.other wise please tell me best solution.

I am attach the data as well as .qvw file with corresponding tables.

Please help me. its urgent.

Re: Is it possible to design?

Gysbert_Wassenaar — Sun, 03 May 2015 10:34:03 GMT

Yes, it's possible. See attached example. The problem you ran into is that set analysis expressions calculate their set at the chart level, not at the level of the dimension values. See this document for more information: Calculating rolling n-period totals, averages or other aggregations

Re: Is it possible to design?

Tue, 05 May 2015 11:29:17 GMT

Hi Gysbert,

Thank you its getting values But i want one more required.If i am not select any month in month field it display year star month value.But i need if i am not select month it display all months values and i am select particular year corresponding year all months values display.Is it possible?

Please help me Gysbert,

Its urgent.

Re: Is it possible to design?

Gysbert_Wassenaar — Tue, 05 May 2015 11:38:36 GMT

Maybe, I don't really understand what you're asking. Perhaps you need an AsOf solution as explained in Calculating rolling n-period totals, averages or other aggregations

Re: Is it possible to design?

Tue, 05 May 2015 14:02:02 GMT

The straight table display only current select month. if i am not select any month at that situation display all months values. Is it possible?

please help me

Re: Is it possible to design?

Tue, 05 May 2015 14:21:07 GMT

The above attached file it display current selection value only. i want display all months values. Is It possible?

please help me

urgent

Re: Is it possible to design?

santhoo_san — Tue, 05 May 2015 14:56:06 GMT

see if this helps.

Re: Is it possible to design?

Tue, 05 May 2015 15:03:47 GMT

Hi Santhosh,

Its ok. But i want display all month values of current month value and previous month value

like example

month current month previous month

jan 200 190

feb 210 200

march 220 210

april

may

june

july

aug

sept

oct

nov

dec ............................................... like way i want to display

Is it possible?

please help me

urgent

Re: Is it possible to design?

santhoo_san — Tue, 05 May 2015 15:11:12 GMT

If you click on your year 2013. You will be able to see all the months' values. since you have only two months' data provided in your sample file, it is showing for two months of latest year.

See the attachment. it is showing you the same result.

Re: Is it possible to design?

santhoo_san — Tue, 05 May 2015 15:12:21 GMT

Ignore the field names .. Dec... Nov. you can read it as Current and Previous

Re: Is it possible to design?

Tue, 05 May 2015 18:20:09 GMT

Thanks santhosh.

It display all month values. But suppose click on may(any month) month.In straight table it show only may month value and corresponding previous month value and deselect the may(any month) month the straight table show all month values.

and one more value like Jan month current month value is displayed and previous month value(means previous year last month value) not displayed.Is it Possible? please provide the solution for the above two problems.

Please help me.

Re: Is it possible to design?

Wed, 06 May 2015 04:53:11 GMT

Hi All,

Any one help me to solve the above two situation.

Please help me its urgent.

Re: Is it possible to design?

nagarjuna_kotha — Wed, 06 May 2015 05:57:38 GMT

Hi,

Kindly find below attached.

Re: Is it possible to design?

Wed, 06 May 2015 09:44:43 GMT

Hi Nagarjuna,

In The above example if your using same expression for both current month value and previous month value..

please verify the table.

any one please help me...

urgent