Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ramusubramani
Not applicable

Drag fields or column in AccessPoint

Hi All

I am new to qlikview. is it possible to end user drag fields into table to see view in Access point.

regards

ramu

Tags (1)
9 Replies
Not applicable

Re: Drag fields or column in AccessPoint

Hi,

They cannot drag fields.

Instead you can provide Adhoc Reporting functionality.

Attached is an example.

ramusubramani
Not applicable

Re: Drag fields or column in AccessPoint

Hi Shruthi

Thanks for inputs and files it is very nice. now I got some idea on Drag fields. Unless we select one dim we could not see the table in your attached adhoc.qvw file

I have small changes in my requirement. I have some fixed dimension and expression in table, in addition if the user select any dimension in "pick dimension list" it should be added or removed.

Can you please help me on the new requirement.

Thanks

regards

ramu

jagan
Not applicable

Re: Drag fields or column in AccessPoint

Hi Ramu,

Dragging is not possible in Qlikview like BO, by selecting the value in the field it is possible.  Check below link hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

jagan
Not applicable

Re: Drag fields or column in AccessPoint

Hi,

If you have fixed dimension and expression then uncheck Enable Condition for the required expression and dimensions.

Also delete the Calculation Condition in General tab to load the chart without selection of dimension and expressions.

Hope this helps you.

Regards,

Jagan.

ramusubramani
Not applicable

Re: Drag fields or column in AccessPoint

Hi Jagan

I did as you said but all dimensions are appearing even some are conditional appearance dim and  that were not selected in "pick list" listbox.

if I not select anything on the "pick dim list" default dim & exp should appear on the table.

please help me on this.

regards

ramu

jagan
Not applicable

Re: Drag fields or column in AccessPoint

Dont remove condition for all dimensions and expressions.

On Oct 31, 2014 6:54 PM, "Ramu subramaniyan" <qcwebmaster@qlikview.com>

ramusubramani
Not applicable

Re: Drag fields or column in AccessPoint

Hi Jagan

I have 5 dim and 1 exp and exp is not conditional appearance. first three dim only conditional appearance rest 4 and 5 should display default in table with exp. Based on the selection dim 1,2,3 will append or removed from table.

can you please help me on this.

regards

ramu


jagan
Not applicable

Re: Re: Drag fields or column in AccessPoint

Hi,

PFA file for soulution, it has three dimensions and 1 expression with no condition, change this file according to your requirement.

Regards,

Jagan.

ashfaq_haseeb
Not applicable

Re: Drag fields or column in AccessPoint

Hi,

Even end user can create his own reports from the available model.

He just need to be taught some basics to write sum() , count() etc. depending on requirements.

Hope it helps.

Regards

ASHFAQ