Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

switch row/column option in qlikview

Hello Everyone,

can someone help me where I can find the  switch row / column option in qlikview graph?

in excel there is an option to change the view (see attached)

is there a way to switch data in the graph only, without changing anything in the load script?

i need the 2 columns format that shows %LOTS & %VOL as graph and the CRITERIA as legend.

thanks in advance.

10 Replies
Frank_Hartmann
Master II
Master II

I guess just switching is not possible.

you will have to CrossLoad your Table and build a new Chart. !

see attached file

hope this helps

pradosh_thakur
Master II
Master II

hi

i guess we are talking about this

1:two chart one above another

2:dimension position changed

3: variable set

4: conditional rendering of two graphs depending on condition

regards

Pradosh

Learning never stops.
pradosh_thakur
Master II
Master II

hi

this is another way

1: only one chart

2: dimensions are embedded with if statement

3:if(v_toggle=0,dim1,dim2) -> first calculated dimension

4:if(v_toggle=0,dim2,dim1) -> second calculated dimension

5: set a button to toggle between 0 and 1

regards

Pradosh

Learning never stops.
Anonymous
Not applicable
Author

thanks frank & prad, i was hoping not to have it included in the script as I am not very good in creating the script.

but I will try both your suggestions.

by the way,, my data changes on a weekly basis.  If my understanding in your given script the number is fixed or can i do the expression inside the script?

Hi prad, i like your switch row button suggestion hope to make like that in my future project.

thanks

pradosh_thakur
Master II
Master II

hi rita

first of all we always change crosstable to normalized table.let me check if it cant be done without it.

If you are going to add extra columns it may create problem  may be not .if we are going to add same type of data row wise or column wise i dont think it will create any problem . data change in the same format will not create any problem weekly or monthly what so ever.

if your question is answered please close the thread.

regards

Pradosh

Learning never stops.
Frank_Hartmann
Master II
Master II

If you do something like this, then your data will be updated everytime you reload your script.

tmp:

LOAD

    CRITERIA, %LOTS, %VOL

From [YOUR-EXCEL-FILE-ADDRESS];

CrossTable(Dim, Value)

LOAD *

Resident tmp;

Anonymous
Not applicable
Author

Hi Frank,

Will try your suggestion.

thanks!

Anonymous
Not applicable
Author

Hi Pradosh,

follow up question.  in my graph the %LOTS & %VOL are from an expression

Count({<Fiscal_Week = {"$(=MaxString(Fiscal_Week))"}>}lot_id)/Count(TOTAL{<Fiscal_Week = {"$(=MaxString(Fiscal_Week))"}>}lot_id)

&

SUM({<Fiscal_Week = {"$(=MaxString(Fiscal_Week))"}>}plan_qty)/SUM(TOTAL{<Fiscal_Week = {"$(=MaxString(Fiscal_Week))"}>}plan_qty)

and my dimension is CRITERIA.

how can I use the toggle button on my graph?

TIA

pradosh_thakur
Master II
Master II

hi Rita

Now it is a complete diff scenario if i understand correctly because %LOTS and %VOL are label name not a dimension or measure name . If you can post a sample data or may be a sample app it would be very helpful to help you.

regards

Pradosh

Learning never stops.