topic Show all Date Dimension Values regardless the data values in QlikView

Show all Date Dimension Values regardless the data values

shyamcharan — Thu, 05 Feb 2015 06:18:03 GMT

Hi Experts,

I have a scenario where I need to show the date values(using drill down object from year, month, etc) on the X-axis regardless of the data values for a particular Asset or Product.

Please find the attached QVW where I have made a selection on Product ID(P44) but the graphs shows data only for 2 months but I would like to see all months irrespective of the data.

Can someone please help me understand how this can be achieved. Moreover, all the source tables are from SQL server database.

So will have to script in DB or in Qlikview?

Thanks heaps in advance.

Re: Show all Date Dimension Values regardless the data values

Thu, 05 Feb 2015 06:26:43 GMT

Hi shyamcharan,

PFA,

For SQL DB tables you need fire query with respective table names which u have,

ex.

your sql connection string required for loading data from sql tables;

you can achieve it by creating ODBC or OLEDB connector...

[Your ConnectionString];

Sql select * from tablename; -or-

Sql select * from viewname; -or-

Directly place query under ConnectionString to load data;

Re: Show all Date Dimension Values regardless the data values

mohammadkhatimi — Thu, 05 Feb 2015 07:17:43 GMT

Hie...

Try this:-

sum({1<FiscalYear=>}[Sales amount])

Hope its helps you

Regards,

Er. Mohammad

Re: Show all Date Dimension Values regardless the data values

shyamcharan — Thu, 05 Feb 2015 09:32:49 GMT

Hi Harshal,

Your solution will not work for me as the graph would have thousands of Assets and if the graph does not show the Cost for one asset rather show the Cost for all Assets its very confusing and not good with too many lines on it.

Thanks,

Shyam

Re: Show all Date Dimension Values regardless the data values

shyamcharan — Thu, 05 Feb 2015 09:33:36 GMT

Hi Mohammad,

My requirement should work many other filter/list boxes. not just one.

Regards,

Shyam.

Re: Show all Date Dimension Values regardless the data values

Thu, 05 Feb 2015 10:27:37 GMT

Hi,

Do you have any sample image for your layout representation please share if you have else create drill-down group ,

chart properties>dimension>Edit Grp.>Edit>drill-down with respective date fields & put created grp. in dimension.