Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

How to create a straight table?

dynamic selections.png

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

1 Solution

Accepted Solutions
9 Replies
ashfaq_haseeb
Champion III
Champion III

anbu1984
Master III
Master III

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

buzzy996
Master II
Master II

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

Anonymous
Not applicable

mukesh24
Partner - Creator III
Partner - Creator III

Hi Sandip,

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

Adhoc reporting in Qlikview

Anonymous
Not applicable

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).

jagan
Luminary Alumni
Luminary Alumni

Hi Sandip,

Check this link for this

Adhoc reporting in Qlikview

Regards,

jagan.

Anonymous
Not applicable

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

agomes1971
Specialist II
Specialist II

Hi,

please see attached. Tab - Quick Report

HTH

André Gomes