topic Re: Need help in QlikView

Need help

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

I have inline load

if i select in june 2016, i need to dsiplay 2 charts

for example: in the first chart India,PAk are 2 top states of sales for the month of june,i wanto show these with previous month May for the same India,pakistan

in the filter if i click on May 2016,top 2 states sales were displayed for may in first chart and in the second chart i need to display the first chart top2 state sales How?

Any oneplease help?

Re: Need help

varshavig12 — Tue, 04 Oct 2016 10:55:24 GMT

https://community.qlik.com/thread/234982

Re: Need help

Marcio_Campestrini — Tue, 04 Oct 2016 10:56:48 GMT

Have you tried to use alternate states? It could be a good solution for you.

About Alternate state.

Re: Need help

punitpopli — Tue, 04 Oct 2016 11:15:19 GMT

You can ignore the date field in your expression and can use max logic for latest month and max-1 for previous month and chart will be conditional shown/ hidden based on the month selected.

It would be better if you can share the QVW file

Re: Need help

varshavig12 — Tue, 04 Oct 2016 11:51:58 GMT

For two different charts:

Re: Need help

varshavig12 — Tue, 04 Oct 2016 11:53:37 GMT

Try this:

Re: Need help

Marcio_Campestrini — Mon, 31 Oct 2016 18:33:40 GMT

Hi Sailaja

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.