topic Re: How to create a straight table? in QlikView

How to create a straight table?

ananyaghosh — Mon, 06 Apr 2015 07:07:34 GMT

In the above picture, in bottom left corner a set of expressions are there and a set of dimension fields are there. Now I have to create a straight table based on the selections. So Can anyone give me an Idea what to do now?

Thanks,

Sandip Ghosh

Re: How to create a straight table?

ashfaq_haseeb — Mon, 06 Apr 2015 07:09:42 GMT

Hi,

Check this link

https://community.qlik.com/docs/DOC-5404

Customizable Straight Table

Regards

ASHFAQ

Re: How to create a straight table?

anbu1984 — Mon, 06 Apr 2015 08:24:31 GMT

Check Report tab in "Expenses Management.qvw" (This app comes with Qlikview examples)

Re: How to create a straight table?

buzzy996 — Mon, 06 Apr 2015 09:10:30 GMT

u can go with

"Whats New in QlikView11.qvw", if u insatlled 11 version in ur PC it's available under this path "C:\Program Files\QlikView\Examples\Documents" and look at tab REPORTS in this application,u have to understand this eles share ur application we will try to do this for u

Re: How to create a straight table?

Anonymous — Mon, 06 Apr 2015 09:21:55 GMT

Hi ,

Hope this link will help you

http://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/

Re: How to create a straight table?

mukesh24 — Mon, 06 Apr 2015 10:19:30 GMT

Hi Sandip,

These can be done through Adhoc Reporting. Please go through below link

Adhoc reporting in Qlikview

Re: How to create a straight table?

Anonymous — Mon, 06 Apr 2015 10:28:42 GMT

Hi,

Please see attachment

Goto Report tab in appn and Now you can create a straight table based on the selections(expressions and dimensions fields).

Re: How to create a straight table?

jagan — Mon, 06 Apr 2015 10:41:03 GMT

Hi Sandip,

Check this link for this

Adhoc reporting in Qlikview

Regards,

jagan.

Re: How to create a straight table?

Anonymous — Mon, 06 Apr 2015 10:43:07 GMT

you will have 2 upload _Dimensions to be used and _metrics to be used in the script

and keep this as list box for the users to pick it

and then create straight table with all dimension which are conditionally active to the selections made by user in the list boxes created

similarly create expressions for all the metrics and keep them conditional to be active on selection by users

as mentions by ppl Whats new in QV 11 .qvw report tab has this one of the sample

with use of couple of functions like Concat, substringcount,GetSelectedCount,Minstring etc

Re: How to create a straight table?

agomes1971 — Mon, 06 Apr 2015 10:53:47 GMT

Hi,

please see attached. Tab - Quick Report

HTH

André Gomes