Dyanamic chart for each product type selected(sales progress by date)

[Anonymous]

Dear All,

Please share your thoughts on below requirement.

we have a chart with x axis as Day and Y axis as Sales. we dispaly always one month data.

My requirement is we have list box product. If user selects 2 products from list box, I have to show 2 charts (1 chart for 1 Product ).

Likewise I have to render charts based on how many products users can select.

For this requirement , I have tried with Trellis chart as Product type as Trellis dimension. Since Scale in Trellis chart is static , this is not much useful approach for me.

Other way is , I can pre built the chart for each product separately and render based on selection. But my Product types are not static. some products may vary for each month. Please find my chart below.

Many Many thanks for your time and help in advance.

Please share your ideas, what can be a better approach for this kind of requiremt..

BR,

Chinna.

[Anonymous]

Dear All,

Any suggestions?

It can't possible in Qlikview?

This is done in Cognos using Repeater table..Want to migrate tht report to Qlikview from Cognos.

Please share any thoughts on the approach.

BR,

Chinna

[qlikviewwizard]

Hi Chinna,

Did you able to achieve this scenario?

Please let us know. Thank you.

[Anonymous · Accepted solution]

Dear All,

Finally I have figured out how we can make this possible. Sharing the document it may be useful for others .

Br,

Chinna

[qlikviewwizard]

Hi Chinna,

Happy to hear.

Please share asap.

[#6]

Thanks for sharing your solution! I like what you did.

[Anonymous]

Hi..Later I came to know a easy way using subfield... PFA..more useful.. BR, Chinna