switch row/column option in qlikview

[Anonymous]

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.

[Frank_Hartmann]

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]

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

[pradosh_thakur]

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

[Anonymous]

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]

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

[Frank_Hartmann]

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]

Hi Frank,

Will try your suggestion.

thanks!

[Anonymous]

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]

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