topic Re: tough task? in QlikView

tough task?

Anonymous — Mon, 13 Oct 2014 14:57:23 GMT

Hi folks,

i have 3 databases calles like a1,a2, a3 storage area nothing( disks) and having 6 dash boards

here i have fileds called used space and non used space

and i have already detils of each dashboard used disk space and unused disk space for every storage areas

example:

stacked barchart( feel like that)

a1: as well as for a2 and a3 also

dashboard1 --used space-notused space

d2 --used space-notused space

d3 --used space-notused space

d4 --used space-notused space

d5 --used space-notused space

d6 --used space-notused space

my req is i want to write expression for what is used space for dashboard1 in A1(storage area) for yesterday vs today

last week vs previous (taken sapce for d1,d2,d3...)

lastmonth vs previous month (d1,d2,d3,d4.....)

Re: tough task?

datagrrl — Mon, 13 Oct 2014 16:25:55 GMT

This isn't very clear. I do not see how you are incorporating a time dimension.

Re: tough task?

Anonymous — Tue, 14 Oct 2014 04:28:08 GMT

i have 3 data storages called SAN ,DB,ETL and having 6 dashboards here

every day all dashboards getting reload .

my question is

i want know the previous day unused space and today unused space

like last week unused space this week unused space

last month vs current month

here dashboard is getting reload it means adding some data everday so unused space is going to decrease .

i want see how much difference previous day to current day .....

i have month field only. no date field how to do this i want show in barchart.

i have fields used space ,unusedspace ,totalspace ...

Re: tough task?

sushil353 — Tue, 14 Oct 2014 04:40:01 GMT

Hi,

See if this can help you: http://www.qlik.com/us/explore/products/qlikview/governance-dashboard

HTH

Sushil

Re: tough task?

ashfaq_haseeb — Tue, 14 Oct 2014 05:45:10 GMT

Hi,

Can you come up with sample data and expected o/p.

Regards

ASHFAQ

Re: tough task?

Anonymous — Tue, 14 Oct 2014 06:02:51 GMT

i can not get it out.

please tell me where u r not understanding

Re: tough task?

ashfaq_haseeb — Tue, 14 Oct 2014 06:05:07 GMT

In this case sit with me on Skype

My Skype ID: ashfaqhaseeb

Regards

ASHFAQ

Re: tough task?

Anonymous — Tue, 14 Oct 2014 06:09:43 GMT

oh thanks for ur support .but now i am in office not at all possible now yar

Re: tough task?

ashfaq_haseeb — Tue, 14 Oct 2014 06:11:13 GMT

Go home take sample data with you and we will sit.

Regards

ASHFAQ

Re: tough task?

Anonymous — Tue, 14 Oct 2014 06:13:33 GMT

now or evening can we sit at 11 pm if possible for u

Re: tough task?

suresh_rawat — Tue, 14 Oct 2014 06:35:58 GMT

Hi,

For this you can create your own date for eg : - using date(today()) in your script and capture daily data.

In Filters, Select - Year & Month.

For Today usage use - sum( {$<year = {$(=Max(year))}>} Used Space/ Unused space)

For Yesterday - sum( {$<year = {$(=Max(year)-1)}>} Used Space/ Unused space)

I hope this will help you.

Regards

Suresh Rawat

Re: tough task?

Anonymous — Tue, 14 Oct 2014 06:38:27 GMT

here i need to create master calendar?

Re: tough task?

suresh_rawat — Tue, 14 Oct 2014 06:48:36 GMT

Hi,

If you want you can create Master Calendar.

Otherwise, when you get data from the data sources through a query just add this column in the query as Today() as date.

Then, after save this data in QVD file. Use this date to get year, month, day for eg: - Year(date) as year.

Re: tough task?

suresh_rawat — Tue, 14 Oct 2014 06:57:02 GMT

Hi,

With the use of the above expression you can get your all results in your dashboards.

1) Current Day Vs Previous Day - Just select Year, Month & Day from your fields.

2) Current Month Vs Previous Month - Just Select Year & Month Field.

Re: tough task?

Tue, 14 Oct 2014 08:22:53 GMT

Hi,

here it will come whole year data right bt i need only today's data and yesterday's data.

Max(year) means it will give whole year data

max(year)-1 means it will give prev year data right.

Re: tough task?

suresh_rawat — Tue, 14 Oct 2014 08:28:03 GMT

Hi,

If you don't want to use Year, Month & Day filter then you can add 1 condition in the above Set Analysis Expression Year(today()), Month(today()), day(today()) for Current Day Vs Previous Day.

For Current Month & Previous Month - Add Year(today()), Month(today()) in the Set analysis Expression.

Re: tough task?

Anonymous — Tue, 14 Oct 2014 08:28:46 GMT

while creating bar chart what are dimension i have to use while using this expressions

and more info i have fileds month ,year and processing date

but there is no relation ship between month, year to processing date ?

what to do ?

Re: tough task?

suresh_rawat — Tue, 14 Oct 2014 08:38:05 GMT

Re: tough task?

suresh_rawat — Tue, 14 Oct 2014 08:39:10 GMT

In this Example I have taken Days as Dimension and calculate data for Current Month , Previous Month and Last Year Current Month Wise data.