topic Re: switch row/column option in qlikview in QlikView

switch row/column option in qlikview

Anonymous — Sat, 07 Oct 2017 09:22:19 GMT

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.

Re: switch row/column option in qlikview

Frank_Hartmann — Sat, 07 Oct 2017 09:51:18 GMT

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

Re: switch row/column option in qlikview

pradosh_thakur — Sat, 07 Oct 2017 10:10:41 GMT

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

Re: switch row/column option in qlikview

pradosh_thakur — Sat, 07 Oct 2017 10:19:35 GMT

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

Re: switch row/column option in qlikview

Anonymous — Sat, 07 Oct 2017 10:35:11 GMT

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

Re: switch row/column option in qlikview

pradosh_thakur — Sat, 07 Oct 2017 10:48:18 GMT

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

Re: switch row/column option in qlikview

Frank_Hartmann — Sat, 07 Oct 2017 10:56:28 GMT

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;

Re: switch row/column option in qlikview

Anonymous — Sat, 07 Oct 2017 11:32:25 GMT

Hi Frank,

Will try your suggestion.

thanks!

Re: switch row/column option in qlikview

Anonymous — Sun, 08 Oct 2017 00:03:11 GMT

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

Re: switch row/column option in qlikview

pradosh_thakur — Sun, 08 Oct 2017 03:44:06 GMT

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

Re: switch row/column option in qlikview

Anonymous — Sun, 08 Oct 2017 11:52:20 GMT

Hi Pradosh & All,

I have attached a sample file of my data.

What I need is for the %LOTS & % VOL in the X axis of the graph.

the %LOTS & %VOL is derived by expressions with CRITERIA as dimension.