topic Re: not working as expected in QlikView

not working as expected

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i have two charts and two listboxes here the issue with alternate state

dimension1 and dimension2

chart1 and chart2

so am using state1 for dimenson 1 and chart1

state2 for diemsion2 and chart2

issue: when i select in chart2 chart 1 also reflecting

what might be the issue?

used xpression for chart1: =sum({<[Type]= ,Dimension2= ,Measure2= >}[Amount])/$(vFormat)

used xpression for chart2: =sum({<[Type]= ,Dimension1= ,Measure1= >}[Amount])/$(vFormat)

variable: vFormat=FormatId

format id is field and having values 1000,10000

thanks

Sony

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 08:27:45 GMT

any idea Ali Ahmad

Re: not working as expected

ogautier62 — Mon, 27 Aug 2018 08:29:36 GMT

Hi,

when you select in a chart it seems not to act as in a listbox,

so <field=> doesn't work,

add 1 before :

{1<type=, .....}

it will work

regards

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 08:34:02 GMT

so i have 5 measures in each measure i need to add? for both the charts?

Re: not working as expected

ogautier62 — Mon, 27 Aug 2018 08:36:26 GMT

yes I think so

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 08:37:15 GMT

but still its reflecting after adding 1 before

Re: not working as expected

ChennaiahNallani — Mon, 27 Aug 2018 08:43:14 GMT

in chart purporting-> general tab

select chart1 = state1 and chart 2 = state2 like below

Re: not working as expected

tresB — Mon, 27 Aug 2018 08:44:44 GMT

Try mentioning state name in the expression as well, like:

sum( {State1<[Type]= ,...>}

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 08:45:18 GMT

yes i have set for both still not working

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 08:52:28 GMT

Still the same reflecting.

More info:

1 its an adhoc report

in first listbox and chart i m selecting 1 dim and 1mesure its showing values

in second listbox and chart am selectng 1 dimension and 1measure the first chart is showing null dimension and some values.

Re: not working as expected

dx_anupam — Mon, 27 Aug 2018 08:57:09 GMT

Hi Sony,

Along with the charts you have to specify respective alternate state to list box as well.

Regards,

Anupam

Re: not working as expected

gavinigovind452 — Mon, 27 Aug 2018 09:35:36 GMT

can you share QVW

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 11:46:46 GMT

any inputs Sunny Talwar

Re: not working as expected

tresB — Mon, 27 Aug 2018 11:51:13 GMT

Could you share a sample app showing the issue?

Re: not working as expected

manoj217 — Mon, 27 Aug 2018 11:55:30 GMT

=sum({state1<[Type]= ,Dimension1= ,Measure1= >}[Amount])/$(vFormat)

=sum({<state2[Type]= ,Dimension2= ,Measure2= >}[Amount])/$(vFormat)

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 11:57:23 GMT

already tried . but still not working

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 11:57:48 GMT

sample its working .. main app in server i cant take it out

Re: not working as expected

manoj217 — Mon, 27 Aug 2018 11:59:54 GMT

check if any states have created in before in the same name

Re: not working as expected

soniasweety — Mon, 27 Aug 2018 12:00:25 GMT

in dimension used below expression

if(SubStringCount(vDimensions,'Type'),1,0) conditional dimenison [bcz its adhoc report]

anything wrong here?

Re: not working as expected

manoj217 — Mon, 27 Aug 2018 12:06:19 GMT

Please go through this https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/